Answer Posted / shar

Hi guys

Here is the answer.

Seq-->copy--->Agg,--> Join ----->Filter -----> DS1
----------> -----> DS2

Explanation:

From seq stg to copy and
from copy send one link to aggregator for counting of rows
and other to join stage for Clubbing.
At join use input column to club. From join to filter and at
filter give conditions at where clause count = 1 output link
-0 and count =2 output link -1.
Finally use Datasets as targets DS1 and DS2.

Ok thats it.

Differentiate between hash file and sequential file?

589

---

Can you explain kafka connector?

781

---

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?

1761

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1088

---

What are iconv and oconv?

779

---

---

Difference between sequential file and data set?

649

---

How the ipc stage work?

680

---

Define project in datastage?

670

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2058

---

Differentiate between data file and descriptor file?

623

---

What is difference between join, merge and lookup stage?

642

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2740

---

why do u need the IOS upgradation in a FC switch

1879

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2187

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1937

---