1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

i have a table
col1
10
20
30
40
10
20
50
my requirement is how to retrive only duplicates like
10
10
20
20
like this how it's possible in SQL?

Question Posted / d.bharath

Answer Posted / d.bharath

Take source and copy,aggregate,transformer and lookup,
1) give one copy output link to aggr,

2)In arggr perform count rows,

3)And in transformer check constrains count>1,count>2

4)And lookup the result of count>2 with the second output
link of copy stage.the you will get the all repeated rows
into on one output dataset.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain engine tier in information server?

650

What are the repository tables in datastage?

819

EXPLAIN SCD

960

If you want to use the same piece of code in different jobs, how will you achieve it?

632

Differentiate between datastage and datastage tx?

591




What are the types of jobs we have in datastage?

666

Differentiate between datastage and informatica?

722

How you can fix the truncated data error in datastage?

1191

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1744

What are the processing stages?

640

Name the command line functions to import and export the DS jobs?

705

How many Key we can define in remove duplicate stage?

819

Can you explain players in datastage?

703

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

963

Can you explain tagbatch restructure operator?

699