What is the function of union transformation?


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

Post New Answer

More Informatica Interview Questions

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  


i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,


how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


What is metadata reporter?

1 Answers   Informatica,


What is a design?

1 Answers  


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


Issue with Update override at Target table in Informatica.

2 Answers  


how can we use sorter transformation in joins?

5 Answers   IBM,


What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,


When do you use mapping parameters? (In which transformations)

1 Answers  


i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,


why we use informatica in our project?

2 Answers   TCS,


Categories