Answer / subhash

SRC--->SORT--->TFM--->TGT

In the Sort Stage, mention the Sort Keys and Set
CreateKeyChangeColumn to TRUE. for each 1st of Key column,
value of the KeyChange column is '1' and for the duplicate
columns, value is '0'.
In the TFM Constraints, give constraint as 'KeyChange=0' and
set '1' for 'Abort After Rows' then the job will abort for 1st
duplicate record.

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

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 the situation where you have applied SCD in your project?

0 Answers  

---

what is set mapping in datastage??

2 Answers   ADP,

---

How to implement complex jobs in data stage?

0 Answers  

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

---

job locking methods? How can we unlock the job?

3 Answers   IBM,

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

---