Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - My source having 10 records but how can i load 20 records in target, i am not bother about duplicates?




572
views
asked marvit September 20, 2014 08:01 AM  

My source having 10 records but how can i load 20 records in target, i am not bother about duplicates?


           

1 Answers



 
answered By vishnoiprem   0  
First Method:

If source is RDBMS than we can use below query in SQL query :

select * from table

union all

select * from table

Second Method


Through normalizer it is possible just give all field's occurrence as 2 time and link it from source. It will work.

Third Method:
use union transformation..connect source to multiple groups of union transformation..
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert