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

Where do the datastage jobs get stored?

1210

---

What are the job parameters?

1219

---

EXPLAIN SCD

1389

---

What is the difference between odbc and drs stage?

1087

---

How to reverse the string using unix?

3502

---

What is aggtorec restructure operator?

1434

---

What all are the different way to run a job?

1090

---

What are the partitioning techniques available in link partitioner?

2272

---

What are the types of containers in datastage?

1187

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1150

---

What are the types of containers?

1227

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2204

---

What are the stages in datastage?

1081

---

What is orabulk stage?

1045

---

What is the use of datastage designer?

1150

---