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

how to add a new records into source?

2058

---

What is a ds designer?

1117

---

How to perform incremental load in datastage?

1265

---

What is the process of killing a job in datastage?

1072

---

How to reverse the string using unix?

3604

---

What are the stages in datastage?

1140

---

Describe the architecture of datastage?

1062

---

Lookup constraints

1308

---

What are the areas of application?

1201

---

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?

2288

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1558

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2262

---

What is the roundrobin collector?

1152

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2501

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

983

---