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 |
What are the different options available for update strategy?
What are the different threads in DTM process?
Where do you create/define mapping parameter and mapping variable?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
What are the different tools in workflow manager?
What are the reusable transforamtions?
What do you mean by channel change?
What is the need for an etl tool?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
what is confirmed fact?
How do you join more than 3 flat files in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?