Answer Posted / venkata ramana

Input Seq File:-

NAME,LOC
Ram,hyd
Ram,ban
Raj,chn
Raj,Pun
Sam,del

seq---Trans---Rem Dups----> Dataset


TRANSFORMER:
------------
STEP1:

Create 3 stage variables like s1,s2,s3

DSLink3.NAME --->s1

If s1<>s3 then DSLink3.LOC else s2:DSLink3.LOC --->s2

s1--->s3

STEP2:

Derivations Column bane

s2------------> LOC


Remove duplicate stage:
-----------------------

Key == NAME

Duplicate To Retain = Last


Output Dataset result:-

NAME LOC
Ram Hyd ban
Raj chn pun
sam del

what is use of SDR function?

4704

---

How many areas for files does datastage have?

634

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2071

---

What are datastage sequences?

663

---

If you want to use a same piece of code in different jobs, how will you achieve this?

782

---

---

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

1622

---

What are the components of ascential data stage?

645

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1076

---

What is ibm datastage?

599

---

What is a quality stage in datastage tool?

620

---

How do you start developing a datastage project?

656

---

CHANGE CAPTURE

883

---

Difference between sequential file and data set?

637

---

How to clean the datastage repository?

689

---

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

532

---