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 is status code?
explain abt union t/r?
Which is better performance wise database or file?How?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
select count(1) from emp? what is the o/p?
What do you mean by enterprise data warehousing?
How to generate the HTML output using Informatica.
whether Sequence generater T/r uses Caches? then what type of Cache it is
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
How to load last 10 records of flat file in to the target?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?