Answer Posted / subhash

According his logic: from aggregator stage: the output is
this: 251,2
456,2
951,1
985,1
the main data is:
251
251
456
456
951
985

If you join these two links then the output will be:
251,2
251,2
456,2
456,2
951,1
985,1

Then your are specifying that count=1 then you get the
unique records. means YOU get: 951,985


in another link count<>1 means YOU get: 251,
251,
456,
456

this is our desired out put, our out put.
the logic explained by Shiva is correct.

how to implement scd2 in datastage 7.5 with lookup stage

5563

---

Have you used Unstructured data?

1275

---

How to manage date conversion in Datastage?

1081

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2193

---

Can you filter data in hashed file?

3736

---

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

2236

---

why do u need the IOS upgradation in a FC switch

2237

---

What are the types of views in datastage director?

1728

---

what is flow of project?

1949

---

What are the stages in datastage?

1043

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2400

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

764

---

Does datastage support slowly changing dimensions ?

1066

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

893

---

Triggers,VIEW,Procedures

1186

---