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.

Answer / jang

It should be a direct 1-1 mapping, source having relational
table and Target a Flat file

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

how i will stop my workflow after 10 errors

2 Answers   HP,

---

What is rank transform?

0 Answers  

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

---

What are the scheduling options to run a sesion?

2 Answers  

---

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

---

what are objects in data warehouse?

2 Answers   Mind Tree,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

what is update strategy transformation ?

7 Answers   TCS,

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---