How will you combine 3 different sources with a single source?
Answer Posted / pooja
hi,
please get clear picture on the Question...
1. wherther all 3 source are in same schma or in differt
schme ..
if its in differnt schma means use joiner
if its same schma means u cn override the SQ query
2. if no.of columne and datatype are same for all the 3
source means you can use union trans....
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Enlist few areas or real-time situations where informatica is required.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Performance tuning in UNIX for informatica mappings?
What will be the approach?
How to use pmcmd utility command?
How to join three sources using joiner?
I have a flat file, want to reverse the contents of the flat file
What are the modules in Power Center
Briefly define a session task?
Which transformation should we use to normalise the COBOL and relational sources?
Different sorts of metadata that stores in the storage facility?
Explain the use of aggregator cache file?
What is an active transformation?
What is status code in informatica?
What are the databases that informatica can connect to windows?