HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

What is active and passive stage?

0 Answers  

---

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,

---

What is audit table?

1 Answers  

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,

---

Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 Answers  

---

EXPLAIN SCD

0 Answers   CTS,

---

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

---