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

EXPLAIN SCD

1383

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2847

---

How to read the length of word in unix?

1368

---

How do y read Sequential file from job control?

15920

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2366

---

Differentiate between data file and descriptor file?

1033

---

Could anyone give brief explanation bout datastage admin

2345

---

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?

2217

---

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

1080

---

What is the purpose of interprocessor stage in server jobs?

2221

---

Describe stream connector?

1296

---

which r the connectors used in san?

2175

---

What all the types of jobs you developed?

1167

---

How rejected rows are managed in datastage?

1495

---

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

1404

---