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 |
how to calculate the optimum cache size in aggregator transformation?
How to display null values on a target & non-null values on a target?
How to extract sap data using informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
Can I create one wrkflw which will run different wrkflws on schedule time?
How to convert flat file into xml file? How to tune joiner?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How to delete first 3 rows & last 3 rows in target table in informatica
What are mapping parametres and variables in informatica?