Answer Posted / subhash

Source
..|
..|
copy--->agg
..|.....|
..|.....|
join stage
....|
....|
Filter stage -----> target1
..|
..|
target2

the main data is:
1
1
2
3
4
4
5
from aggregator stage, the output is:
1,2
2,1
3,1
4,2
5,1

If you join these two links then the output will be:
1,2
1,2
2,1
3,1
4,2
4,2
5,1

Then specify the count<>1 in the Filter for target1 then you get the duplicate records. means YOU get:
1
1
4
4

in another link for target2, give count=1. means YOU get:
2
3
5

What is a ds designer?

640

---

client know skid info?

1633

---

How many types of sorting methods are available in datastage?

631

---

Name the different types of Lookups in Datastage?

729

---

What are the different types of lookups in datastage?

628

---

---

How to convert RGB Value to Hexadecimal values in datastage?

3457

---

how to sort two columns in single job in datastage.

2529

---

What is a quality stage in datastage tool?

625

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1631

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3378

---

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

538

---

What are the job parameters?

705

---

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

1750

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

968

---

How a routine is called in datastage job?

605

---