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

Name the command line functions to import and export the DS jobs?

707

---

What is the difference between in process and inter process?

665

---

What are system variables and sequencers in datastage

608

---

How do you schedule or monitoring the job?

667

---

How to manage date conversion in Datastage?

640

---

---

CHANGE CAPTURE

891

---

how to sort two columns in single job in datastage.

2529

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2284

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1118

---

Difference between in process and inter process?

697

---

What are the various kinds of containers available in datastage?

563

---

How can one find bugs in job sequence?

785

---

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

1750

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

670

---

Where do the datastage jobs get stored?

731

---