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
- 9137 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 an active transformation?
What are active transformations.
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
What is the session task and command task?
What is aggregate cache in aggregator transformation?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
What is incremental aggregation?
How the Informatica Server reads perameter file?
If informatica has its scheduler why using third party scheduler?
what is hash table in informatica?
what is the hint? how to use it to reduce the query processing in program?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
Teradata 
