How to load relational source into file target?
Answer Posted / 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 |
Post New Answer View All Answers
How union transformation is used?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Can we create a node as a gateway node and the same node can be assigned to a grid?
design of staging area?
Design time, run time. If you don't create parameter what will happen
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is target designer and target load order?
What is source qualifier transformation in informatica?
How to load the data from people soft hrm to people soft erm using informatica?
What all join we can perform in LOOKUP transformation?
What is joiner change?
What is deployment group?
What are mapplets? How is it different from a Reusable Transformation?
Write the different tools in the workflow manager?
Explain the different kinds of facts.