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
How does a sorter cache works?
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 fact table? Explain the different kinds of facts.
What are the types of schemas we have in data warehouse.
What is event and what are the tasks related to it?
What are pre and post-session shell commands?
How to do unit testing in informatica? How to load data in informatica ?
Is there any way to read the ms excel datas directly into informatica?
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
What are different types of transformations available in informatica?
what is the size of your data warehousing?
Enlist some properties of sessions.
How to partition the Session?
Enterprise data warehouse your projects phase by phase explain?
Explain how to import oracle sequence into informatica?