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 

On which interface you will be working as a developer?

1049

---

What is the difference between an operational datastage and a data warehouse?

1155

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2180

---

What is the importance of the exception activity in datastage?

1073

---

Explain usage analysis in datastage?

1171

---

What are data elements?

1179

---

what is the use of surogate key in datastage

2310

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3347

---

Why do we use link partitioner and link collector in datastage?

1139

---

How many areas for files does datastage have?

1155

---

How to reverse the string using unix?

3515

---

Explain Quality stage?

1162

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2498

---

What is a datastage job?

1013

---

How to Remove Duplicate using SQL?

1373

---