Answer / ramu

src.....>agg........>t/r..........2trgs
take src as seqfiles and take aggregater stage is for
calculate count of records based on name coloumn,next take
the transformer is for apply constraints like cnt=1 then go
for trg1

Answer / subhash

1) If SRC is either Oracle or Seq File

SRC--->AGG---->fILTER---->TGT1
...................|
...................|
..................TGT2

the main data is:
sam
ram
sam
raj
ram
from aggregator stage, the output is:
sam,2
ram,2
raj,1

Then specify the count<>1 in the Filter for TGT1 then you get:
ram
sam

in another link for TGT2, give count=1. THEN YOU GET:
raj

2) If SRC is DataBase,

Orcl Conector----->Filter---->TGT1
.......................|
.......................|
......................TGT2

SELECT NAME, COUNT(NAME)
FROM EABLE_NAME
GROUP BY (NAME)
from the Above Query, the output is:
sam,2
ram,2
raj,1

Then specify the count<>1 in the Filter for TGT1 then you get:
ram
sam

in another link for TGT2, give count=1. THEN YOU GET:
raj

Answer / reddymkl.dwh

Small correction Ramu, Instead of Transformer stage use Filter stage it will give performance gain.

Answer / cva

take seqfile for loading src then take filter stage and take
two outputs from filter . write condition in filter stage
use where clause=col like 'sam' and col like 'ram' for one
trg and for second also like that.

Difference between in process and inter process?

0 Answers  

---

In Datastage, how you can fix the truncated data error?

0 Answers  

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

How many areas for files does datastage have?

0 Answers  

---

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

---

how to find no.of records in sequntial file itself?

4 Answers  

---

Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

---

What is apt_config in datastage?

0 Answers  

---

What is orabulk stage?

0 Answers  

---

What is a datastage job?

0 Answers  

---

Pls tell me what is troubleshooting in datastage view?

1 Answers  

---

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

---