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?
Answer Posted / 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 |
Post New Answer View All Answers
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is Cognos script editor?
What is the scenario which compels informatica server to reject files?
tell me 5 session failure in real time how can you solve that in your project?
How you can differentiate between connected lookup and unconnected lookup?
What is the difference between informatica 7.0 and 8.0?
what is mean by complex business rule ?
What is a joiner transformation?
can u give example for factless fact table
How do you migrate data from one environment to another?
Enlist the differences between database and data warehouse.
What is Session and Batches?
What is the commit type if you have a transaction control transformation in the mapping?
Explain in detail about scd type 1 through mapping.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?