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
- 9090 Views
- TCS, I also Faced
- E-Mail Answers
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
what are the deliverables?in your project?
tell me about your project functionality
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How we can create indexes after completing the load process?
What is transformation?
In informatica workflow manager, how many repositories can be created?
Differentiate between a repository server and a powerhouse?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the informatica performance improvement tips
How can we use mapping variables in informatica? Where do we use them?
What is union transformation?
How can you validate all mappings in the repository simultaneously?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is rank index in rank transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
