Can we use Union Transformation for Heterogeneous sources?
i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
- 3 Answers
- 9722 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandrababu.sarupuru
Union Transformation allows the Hetrogeneous sources .
So you can join the sources which are having same metadata.
| Is This Answer Correct ? | 12 Yes | 0 No |
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
How can we get two output ports in un-connect transformation?
Where should yoU place the flat file to import the flat file defintion to the designer?
Define informatica repository?
What is informatica powercenter repository?
What are ETL Tools?
What is decode in informatica?
What is the surrogate key?
what is unit testing?tell me proceedure
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
Teradata 
