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
Can we get 1st record through Informatica(without sequence number).
What is expression transformation?
How might one distinguish in the case of mapping is right or not without associating session?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain scd type 3 through mapping.
What is lookup transformation?
How do you migrate data from one environment to another?
How to do unit testing in informatica? How to load data in informatica ?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the way to execute pl/sql script using informatica mapping?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How we can use union transformation?
How an expression transformation differs from aggregator transformation?
What differs when we choose the sorted input for aggregator transformation?