Answer Posted / shar

Well
The prime difference is
lookup reject link can collect all unmatched primary mismatched data.
Where as
in merge stage, using reject link(s) it will allow us to identify from which update datasets records got rejected.
n in addition to this as we know
lookup supports only one reject link and merge supports as many no. of updates so many no. of reject links.
thats it.

Describe stream connector?

1271

---

What are the functionalities of link collector?

1061

---

Describe routines in datastage? Enlist various types of routines.

975

---

What is "fatal error/rdbms code 3996" error?

1229

---

What are the steps required to kill the job in Datastage?

1176

---

How do u convert the columns to rows in datastage?

1164

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3725

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1989

---

how to abort the job its matain duplicates?

2556

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

751

---

Why do we use exception activity in Datastage?

1260

---

what is flow of project?

1963

---

Terminate Activity

1253

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2195

---

what are the errors,warnings in datastage

2649

---