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

Answer Posted / sujana

use union transformation..connect source to multiple grps of union transformation..

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2083


What are the types of lookup transformation?

640


can anyone suggest best free Talend data integration training online

1270


Design a mapping to load a target table with the following values from the above source?

889


What is Index Caches size?

629






Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1244


Explain sessions?

611


Explain about Informatica server process that how it works relates to mapping variables?

633


Where are the source flat files kept before running the session?

632


How do you change a non-reusable transformation to reusable transformation?

604


tell me 5 session failure in real time how can you solve that in your project?

1638


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

634


What is Cognos script editor?

3797


scenario where i can use only concurrent execution of workflow.

2554


How to configure mapping in informatica?

684