Answer Posted / anki_sri

Src>> Sort1 >> Sort2 >> Transfrmr >> Trgt

Sort1 --> sort with class_id and marks as well.
Sort2 --> declare key as id and select Dont Sort(Previously Sorted) and set create cluster key change column as True.

Transfrmr --> set two stage variables.
StageVar1=If Clusterkeychange=1 then Clusterkeychange else StageVar+1

StageVar=StageVar1
Create a new row as rank in transfrmr output and map StageVar1 to rank

What are the stages in datastage?

1137

---

Explain usage analysis in datastage?

1224

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2267

---

Describe link sort?

1059

---

Describe the architecture of datastage?

1061

---

what is the use of skid in reporting?

2426

---

Name the different types of Lookups in Datastage?

1313

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1115

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1461

---

What is difference between symmetric multiprocessing and massive parallel processing?

1199

---

What is ibm datastage flow designer?

1204

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1430

---

What is a quality stage in datastage tool?

1128

---

What is difference between join, merge and lookup stage?

1149

---

How do you import and export the datastage jobs?

1209

---