Answer Posted / chaint

source1(112345) ----- lookup stage- reference lookup
on(source2 output)--reject link(1144) --output(235)
source2(112345) -- sort( get count) -> filter(only unique)

we would require two source..
one original and other only (non repeated records)

we will have a lookup stage with source1 as input and
source2 as reference lookup..
in lookup stage we will have a reject link(1144) non matched
records.. and output will be(235).

Kindly correct me if i m wrong

What is the purpose of interprocessor stage in server jobs?

2286

---

What are the types of hashed files in data stage

1146

---

describe the Steps to confiure a Qlogic switch

2434

---

How to clean the datastage repository?

1176

---

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

819

---

how to delete one row in target dataset

3162

---

What are the important features of datastage?

1197

---

What is the purpose of pivot stage?

1223

---

Which algorithm you used for your hashfile?

1226

---

What are the areas of application?

1191

---

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

1206

---

Can you explain engine tier in information server?

1180

---

Define project in datastage?

1146

---

What are the types of containers and how to create them?

1020

---

What is orabulk stage?

1101

---