Answer Posted / ankit gosain

Hi All,

Create a job design like below:

SeqFile--->SortStage--->Transformer--->RemoveDup--->SeqFile

Steps:
-----
1. At sort stage, take sort key = Company and sort key mode
= Don't sort (Previously Grouped) & take a
CreateClusterKeyChange column.

2. At Transformer Stage, create two stage variables:
temp of integer type with 0 as default,
temp1 of varchar type.
now, write in their derivation:
if clusterKeyChange=1 then 1 else temp+1----temp
if clusterKeyChange=1 then Location else temp1:',':Location-
---temp1
Create one o/p column (say count).
Now derive the o/p derivation columns as:
Company--------Company
temp1----------Location
temp-----------Count

3. At remove duplicate stage, take key=Company and
Duplicate to retain = Last
now just drag and drop the i/p columns to o/p derivation
& you will get the desired result.

For further queries, mail me on ankitgosain@gmail.com

Cheers,
Ankit :)

Have you have ever worked in unix environment and why it is useful in datastage?

1133

---

Difference between in process and inter process?

1242

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1288

---

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

3250

---

What are the different options associated with dsjob command?

1442

---

How can one find bugs in job sequence?

1424

---

What are the partitioning techniques available in link partitioner?

2279

---

Define Job control?

1153

---

What are the different type of jobs in datastage?

1045

---

What are datastage sequences?

1126

---

What is the flow of loading data into fact & dimensional tables?

1067

---

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

1103

---

Which commands are used to import and export the datastage jobs?

1414

---

What is aggtorec restructure operator?

1457

---

Triggers,VIEW,Procedures

1227

---