Answer Posted / nagam

seq.file----->sort------>filter----2datasets

in sort stge create key change column and then filter stage
write the condition on based on keychange column keychange
column =1 uniq data keychange<>0 duplicate data we can get

If wrong please tell me

How many types of hash files are there?

1185

---

How many areas for files does datastage have?

1154

---

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

---

How we can covert server job to a parallel job?

1147

---

What is the difference between the local container and shared container?

1103

---

How do y read Sequential file from job control?

15963

---

How do you generate sequence number in datastage?

1094

---

How to RD using transformer?

1425

---

What a datastage macro?

1060

---

Why we use surrogate key?

1235

---

Name the different sorting methods in datastage.

1050

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

781

---

What is the difference between informatica and datastage?

1229

---

Describe the architecture of datastage?

1010

---

How to perform incremental load in datastage?

1203

---