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 :)

project Steps,hits, Project level HArd things,Solved methods?

2185

---

what are the errors,warnings in datastage

2768

---

What steps should be taken to improve Datastage jobs?

1121

---

Differentiate between Join, Merge and Lookup stage?

1143

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2288

---

What is the difference between an operational datastage and a data warehouse?

1212

---

What is aggtorec restructure operator?

1530

---

Is the value of staging variable stored temporarily or permanently?

1056

---

Can you highlight the main features of ibm infosphere information server?

1126

---

What all the types of jobs you developed?

1249

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2324

---

Does datastage support slowly changing dimensions ?

1158

---

Difference between sequential file and data set?

1261

---

What is the precedence of stage variables,derivations, and constraints?

1127

---

What is meta stage?

1243

---