Answer / ashok

TRANSFORMER:
------------
STEP1:
Take 3 stage variables
NAME--->s1
if s1<>s3 then LOC else s2:LOC --->s2
s1--->s3
STEP2:
In derivations s2--->LOC Field
Remove duplicate stage:
-----------------------
Retaining last

Answer / vikram

1)Sort the input (name as key),keychange colum =true
we will get
name loc key..
ram hyd 0
ram ban 1
raj chn 0
raj pun 1
sam del 0

2)transformer
  stage variable 
  svVar=if key..=0 then loc else svVar:loc
3) remove duplicate stage 
retain duplicate last 

Answer / 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 the difference between datastage and informatica?

0 Answers  

---

How complex jobs are implemented in datstage to improve performance?

0 Answers  

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

---

How to create a doccument in datastage?

1 Answers   Cap Gemini,

---

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---

---

How many types of hash files are there?

0 Answers  

---

how CAN we remove duplicates in dataset?

2 Answers   IBM,

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

---

what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

12 Answers   Wipro,

---

detail about sdlc

4 Answers  

---

What is the difference between validate and compile?

1 Answers   CTS,

---