Answer Posted / ankit gosain

Hi ALL,

Job Design:

SourceSeqFile--->SortStage--->Transformer--->TgtSeqFile

1. In Sort Stage, take two key, name & company and then go
to options and create a keyChange column.
2. In transformer stage, create a stage variable of integer
type (say Var1) and write in it's derivation:
if keyChange=1 then 1 else Var1+1
3. Now create a new column in tgt (say count) and in
transformer, assign that Var1 to the derivation of count.
4. Goto o/p tab of transformer and there sort the data on
count column.
You'll get the desired output.

If you have more queries, you can mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

What are the different type of jobs in datastage?

1035

---

What is difference between server jobs & parallel jobs?

1024

---

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

2210

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2089

---

what is flow of project?

1980

---

What are routines in datastage? Enlist various types of routines.

1084

---

Lookup constraints

1236

---

Differentiate between operational datastage (ods) and data warehouse?

1155

---

What are the differences between datastage and informatica?

1162

---

Can you explain tagbatch restructure operator?

1158

---

What are stage variables?

1191

---

what is the use of skid in reporting?

2366

---

Describe the architecture of datastage?

996

---

What is ibm datastage?

955

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3241

---