Answer Posted / bhavani

we can acheive this using transformer stage:
1. Check the record count using AGGREGTOR stage and have a column count
2. In the transformer initiate a loop with condition @ITERATION <=count. and loopvar = @iteration
3.if @INROWNUM = loopvar then right(left(@iteration),1) --> output value

Now the result will be 2
5
6

Let me know if this is correct.

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

2166

---

Differentiate between operational datastage (ods) and data warehouse?

1116

---

How many Key we can define in remove duplicate stage?

1310

---

What are the functionalities of link partitioner and link collector?

950

---

What is a merge?

1076

---

How can one find bugs in job sequence?

1316

---

What are the different plug-ins stages used in your projects?

1027

---

What are the areas of application?

1090

---

What are the types of containers?

1141

---

Differentiate between hash file and sequential file?

998

---

How do you run datastage job from the command line?

1027

---

CHANGE CAPTURE

1257

---

What are orabulk and bcp stages?

1068

---

sed,awk,head

1409

---

Why do you need stage variables?

1132

---