Answer Posted / 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 

What is meta stage?

1177

---

What are the features of datastage flow designer?

1036

---

How to reverse the string using SQL?

1521

---

in oracle target stage when we use load option and when we use upsert option?

2279

---

How many types of stage?

1175

---

Explain entity, attribute and relationship in datastage?

1092

---

Difference between in process and inter process?

1225

---

How many Key we can define in remove duplicate stage?

1379

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1533

---

Does datastage support slowly changing dimensions ?

1103

---

What are stage variables and constants?

1145

---

Can you explain players in datastage?

1189

---

Why do you need stage variables?

1180

---

What a datastage macro?

1056

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2291

---