How will you combine 3 different sources with a single source?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / madhu
we can use sourcequalifier transformation
or union transformation to combine different source to a
single source
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rkumar.etl
use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.
Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between informatica 7.0 and 8.0?
what is the drillup & drill down?and use of the drill up and drill down?
in a table it has 200 rows the query is select 150 from tablename.whats the output
What happens if we dont select data driven option?
How identifying bottlenecks in various components of informatica and resolving them?
What is lookup transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How can we use mapping variables in informatica? Where do we use them?
Define pmcmd command?
can we generate reports in informatica ? How?
What are the different types of repositories created using informatica?
who is the best faculty for informatica in hyderabad ameerpet?