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.

Which warehouse using in your datawarehouse

2233

---

What are the components of ascential data stage?

1240

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2223

---

How to convert RGB Value to Hexadecimal values in datastage?

4052

---

What is active and passive stage?

1464

---

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

1341

---

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

2559

---

What are stage variables and constants?

1193

---

What is the importance of the exception activity in datastage?

1111

---

Name the different types of Lookups in Datastage?

1311

---

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

1185

---

On which interface you will be working as a developer?

1101

---

What is the difference between validated and compiled in the datastage?

1366

---

Why do we use exception activity in Datastage?

1368

---

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

2775

---