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

what is ds administrator used for?

1219

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2520

---

What is data partitioning?

1268

---

What are the different type of jobs in datastage?

1082

---

How to Remove Duplicate using SQL?

1424

---

What is the purpose of interprocessor stage in server jobs?

2294

---

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

2853

---

What are the functionalities of link partitioner?

1067

---

What are the types of views in datastage director?

1825

---

What is difference between join, merge and lookup stage?

1149

---

I have a few records just I want to store data in to targets cycling way how?

2414

---

Difference between in process and inter process?

1305

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1581

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1271

---

What is the importance of the exception activity in datastage?

1111

---