one file contains
col1
100
200
300
400
500
100
300
600
300
from this i want to retrive the only duplicate like this
tr1
100
100
300
300
300 how it's possible in datastage?can any one plz explain
clearley..........?
Answer Posted / vinod upputuri
In order to collect the duplicate values:
first cal the count output col in aggregator stage
group by col.
aggregator type: count rows.
count output col..
next, use the filter stage to separate the multiple occurrence.
finally, use the join stage or lookup stage to map the two
tables join type INNER ..
then u can get the desired output..
Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What are the different kinds of views available in a datastage director?
How do you register plug-ins?
What is a ds designer?
Differentiate between operational datastage (ods) and data warehouse?
What is the use of hoursfromtime() function in transformer stage in datastage?
Define Routines and their types?
What are constraints and derivations?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Which algorithm you used for your hashfile?
How do you remove duplicate values in datastage?
What is apt_config in datastage?
Is the value of staging variable stored temporarily or permanently?
What are the types of containers?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How do you generate sequence number in datastage?