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

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

1414

---

What are the functionalities of link partitioner?

1022

---

client know skid info?

2084

---

What could be a data source system?

1011

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2447

---

How rejected rows are managed in datastage?

1522

---

What are the stages in datastage?

1084

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2903

---

What are the types of views in datastage director?

1775

---

Differentiate between datastage and datastage tx?

1051

---

I have a few records just I want to store data in to targets cycling way how?

2366

---

Differentiate between Join, Merge and Lookup stage?

1094

---

why do u need the IOS upgradation in a FC switch

2283

---

what is flow of project?

2002

---

what is repositery?

1843

---