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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

how to duplicates from expression transformation without using sorter before that

1 Answers  


Why we use partitioning the session in informatica?

2 Answers  


What are the popular informatica products?

0 Answers  


I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,


can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,


Explain how many types of dimensions are available in informatica?

0 Answers  


how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,


how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,


can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,


Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  


Differences between connected and unconnected lookup?

0 Answers  


Categories