How to load relational source into file target?
Answers were Sorted based on User's Feedback
Answer / rkumar.etl
use mapping designer create source db file as well as tgt
flat file with required column information .
While creating session provide the tgt file directory to get
the information.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / jang
It should be a direct 1-1 mapping, source having relational
table and Target a Flat file
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kammari.krishnaiah
load the data form source system to target in two ways.
one is directly storing another one is mapping (etl)in
infirmatia
Is This Answer Correct ? | 0 Yes | 2 No |
As union transformation gives UNION ALL output, how you will get the UNION output?
How can u work with remote database in informatica?did you work directly by using remote connections?
what is unique constraint error ?
Explian the connected and unconnected lookup transformation
what is the difference between static and dynamic
What are the different types of Type2 dimension maping?
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
What are the different options used to configure the sequential batches?
How to Create a folder using pmrep command?
Explain reference cursor?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain scd type 3 through mapping.