One source and 3 targets
1st row-1st target
2nd row-2nd target
3rd row-3rd target
4th row-1ist target how will u do?

Answer Posted / sushma

Source ---> SQ ---> Expression ---> Router ---> Targets

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a joiner transformation and why it is an active one?

653


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8913


What is an active transformation?

737


can we override a native sql query within informatica? How do we do it?

743


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9283






I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

898


How to improve the performance of a session using sorter transformation?

788


Briefly define a session task?

674


What is a sequence generator transformation?

666


What are the prerequisite tasks to achieve the session partition?

807


In which transformation you cannot drag ports into it?

908


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1537


How to configure mapping in informatica?

772


How do you load unique records into one target table and duplicate records into a different target table?

827


What are the advantages of informatica?

661