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 |
explain different types of modeling.
What is the default join that source qualifier provides?
What is IQD file?
Is it possible to define a single node as a Gateway node as well as worker node?
Do joiner transformation use cache? If so describe?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
difference between stop and abort
List the transformation in informatica.
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
What are the databases that informatica can connect to windows?
What is a sorter transformation?
Why update strategy and union transformations are active? Explain with examples.