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

Differentiate between Join, Merge and Lookup stage?

1090

---

How many types of stage?

1176

---

Describe the main features of datastage?

1074

---

What are the job parameters?

1221

---

What is the difference between odbc and drs stage?

1091

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2718

---

What is the difference between server job and parallel jobs?

1152

---

table actions available in oracle connector?

1605

---

How to read the length of word in unix?

1377

---

Can you define merge?

1118

---

What are the different options associated with dsjob command?

1430

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1036

---

CHANGE CAPTURE

1298

---

What are the components of ascential data stage?

1185

---

Why do we use link partitioner and link collector in datastage?

1134

---