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

What is the use of datastage designer?

1221

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2212

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2417

---

Where the datastage stored his repository?

1141

---

Could anyone give brief explanation bout datastage admin

2408

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3184

---

Define orabulk and bcp stages?

1179

---

Have you used Unstructured data?

1374

---

How to read the length of word in unix?

1435

---

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

2268

---

How will you move hashed file from one location to another location?

2217

---

What steps should be taken to improve Datastage jobs?

1121

---

What is the difference between datastage and datastage tx?

1117

---

Why fact table is in normal form?

1313

---

Can you implement SCD2 using join, transformer and funnel stage?

1606

---