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.

What is a folder? Difference types of stages?

619

---

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 ?

1623

---

Whats difference betweeen operational data stage (ods) and data warehouse?

660

---

table actions available in oracle connector?

1084

---

What is merge stage?

758

---

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

513

---

what are the devoleper roles in real time? plz tell i am new to datastage....

1630

---

How you can fix the truncated data error in datastage?

1187

---

What are routines in datastage? Enlist various types of routines.

621

---

Can you define merge?

660

---

What are the functionalities of link partitioner?

610

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2422

---

How do you register plug-ins?

594

---

how many rows sorted in sort stage by default in server jobs

3549

---

Is it possible to query a hash file?

1554

---