Answer / vinod upputuri

First use the seq filestage then use the copy stage after
the copy stage one link is going to agregator stage there we
will calculate the count of records after the agregator
stage use filter stage for finding uniq records then those
records are connected to the lookup as a reference link. the
main link for lookup is comming from copy stage. Then
matching records are uniq else duplicate.

Agre--->filter
| |
Seq--->copy---->Lookup---->uniq
|
|
duplicate.

In agregator use count rows.

Answer / subhash

According his logic: from aggregator stage: the output is
this: 251,2
456,2
951,1
985,1
the main data is:
251
251
456
456
951
985

If you join these two links then the output will be:
251,2
251,2
456,2
456,2
951,1
985,1

Then your are specifying that count=1 then you get the
unique records. means YOU get: 951,985


in another link count<>1 means YOU get: 251,
251,
456,
456

this is our desired out put, our out put.
the logic explained by Shiva is correct.

Answer / siva

src-->copy-->agg
| |
| |
join stage--filter--uniq
|
|
dup
this is senario ans

plz do this u get correct answer

thanks
siva

Answer / binayak mohapatra

seq-agg-copy-filt1-tgt1
Again from that agg-filt2-tgt2
In agg group=empid
        count=rowcount
        outputcount=empid
In agg column  create another column like count_empid and map it.
in filt1 count_empid>1 and map into tag 1
then  you can take input from another copy source then filter2 put a condction like count_empid=1 and map them into tgt 2

Answer / vinod upputuri

Appreciate your Answer but it was wrong..because if you are using Agregator stage it will give only unique records with record count. so how can u print all the duplicate records.


in the above senario:

input to agregator stage: 251,251,456,456,951,985
i used count rows.
so, the o/p is 251,2
456,2
951,1
985,1
if U use the Filter stage then what is the output:
O/P1:
251
456

O/P2:
951
985

Unfortunately this is not the answer we are required...

This is not as simple as U think...i implemented it before posting!!!!!

Answer / pnvnreddy

Hi Shiva ur right

---------Agg -tar1
----------/ \ -/
seq---copy--join---filter---tar2

in Agg
Agg type=count

in filter
count=1-----tar1
count>1-----tar2

Answer / 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.

Answer / msbharathi

- > Unique
Sq File - > Aggregate - > Transformer |
- > Duplicate

1. Read data in seq file stage.
2. In Aggregate stage group by EID and count the number of rows in Count column
3. In transformer stage create loop condition as @ITERATION<= DSLink6.Count and derivation as EID = EMPNO.
4. In unique output tab use constraint count<=1 and in duplicate output tab use constraint count>1

Answer / vinod upputuri

Unfortunately, I didn't got the logic behind the YOUR answer.

According your logic: from aggregator stage: the output is this: 251,2
456,2
951,1
985,1
the main data is:
251
251
456
456
951
985

If you join these two links then:
251
251
456
456
951
985
251,2
456,2
951,1
985,1

Then your are specifying that count=1 then you get the unique records.

in another link count<>1 means YOU get 251
456

Unfortunately this is not our desired out put, our out put is: 251
251
456
456

SO, YOUR LOGIC IS NOT ACCEPTABLE. TRY TO THINK FOR DESIRED OUTPUT !!!!

in order to get the desired out put i using the lookup-stage
in lookup i am going to lookup the out put from filter stage which is 951,985 with main data there i will specify the condition as reject:
so YOU will get the desired output!!!!!

If you can prove the above logic is wrong send me the mail!!!!

Answer / sarath

seq---->aggr--->filter---- ds1
|
-->ds2

how can u handle null values in transformer stage.

7 Answers  

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

0 Answers  

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

How do u view log file for a particular job?

6 Answers   HP,

6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,

Define project in datastage?

0 Answers  

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

1)Source file contains one record, I want 100 records in target file.

3 Answers  

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,