Answer Posted / venkatesh

The flow will be like this

src----->sorter---->transformer----->remove duplicates---->trg
SORTER
in sorter sort by the key=empname and create keychange column

TRANSFORMER
create two stage variables stg1 and stg2
if key change=1 then company else stg2 :',': company |stg1
_____________________________________________________|_____
|
stg1 |stg2

connect the stg1 as out put column and empname as output

from transformer connect to the remove duplicates
REMOVE DUPLICATES
key=empname
duplicates to retain=last
connect to the trg

u will get the output

Lookup constraints

1306

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2247

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2137

---

What is the process of killing a job in datastage?

1067

---

Define ds designer?

1326

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1465

---

To see hidden files in LINIX?

1586

---

Define Merge?

1374

---

What is the difference between datastage and informatica?

1181

---

What is the command line function to import and export the ds jobs?

1189

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2852

---

What is the difference between server job and parallel jobs?

1198

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4092

---

Difference between sequential file and data set?

1259

---

What are routines in datastage?

1379

---