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
what is the size of u r source(like file or table)?
What are the different types of repositories created using informatica?
How can we use mapping variables in informatica? Where do we use them?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Name the different lookup cache(s)?
What are the transformations that are not supported in mapplet?
How to handle decimal places while importing a flatfile into informatica?
Explain the code page compatibility?
Which is the t/r that builts only single cache memory?
What do you mean incremental aggregation?
What all are steps in up gradation of Informatica server?
Different qualification between a related rotate toward the sky and isolates look upward?
How would you join a node to the already existing domain?
What is fact table? Explain the different kinds of facts.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?