How is union transformation utilized?


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

Post New Answer

More Informatica Interview Questions

What are connected or unconnected transformations?

0 Answers   Informatica,


What is fact table? Explain the different kinds of facts.

0 Answers  


What are events in workflow manager?

1 Answers   Accenture, IBM,


If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,


Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,






how will you get 21 to 30 record from 50 records?

6 Answers  


In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,


I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  


Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,


i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 Answers  


How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,


How is union transformation utilized?

0 Answers  


Categories