How to load relational source into file target?

Answers were Sorted based on User's Feedback



How to load relational source into file target?..

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

How to load relational source into file target?..

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

How to load relational source into file target?..

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

Post New Answer

More Informatica Interview Questions

What are the different options available for update strategy?

0 Answers  


What are the different threads in DTM process?

1 Answers  


Where do you create/define mapping parameter and mapping variable?

1 Answers  


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?

1 Answers   Thomson Reuters,


What are the different tools in workflow manager?

1 Answers  


What are the reusable transforamtions?

1 Answers  


What do you mean by channel change?

0 Answers  


What is the need for an etl tool?

0 Answers  


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?

3 Answers  


what is confirmed fact?

2 Answers  


How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  


Categories