To achive the same in datastage we can use aggregator stage. Check the b

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 / geetha

Answer Posted / geetha

To achive the same in datastage we can use aggregator stage.

Check the below link
http://mydatastage-notes.blogspot.in/p/aggregatorstage.html

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3282

What is ibm datastage?

615

What is difference between join, merge and lookup stage?

648

Define ds designer?

785

Lookup constraints

855

Explain datastage architecture?

831

table actions available in oracle connector?

1103

What are the stages in datastage?

645

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

968

how do u catch bad rows from OCI stage? And what CLI stands for?

2302

What is the difference between operational data stage (ods) and data warehouse?

687

Explain the importance of surrogate key in data warehousing?

725

How the ipc stage work?

684

Explain the datastage parallel extender (px) or enterprise edition (ee)?

747

What is the project in datastage?

681