Interested to Buy Any Domain ? << Click Here >> for more details...
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..........?
- 8 Answers
- 12960 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pooja
Follow the following steps -
1. Seq file stage - Read the input data in seq file - input1.txt
2. Aggregate stage - count the number of rows (say CountRow) for each ID(group=ID)
3. Filter stage - Filter the data where CountRow<>1
4. Perform join on the output of the step 3 and input1.txt.
You will get the result :)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between server jobs & parallel jobs?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is difference between server jobs & parallel jobs?
How will you move hashed file from one location to another location?
What are the difference types of stages?
how to export or import the jobs in .ISX file
how to write server Routine coding?
What are stage variables, derivations and constants?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are the different options associated with dsjob command?
How to perform incremental load in datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is a quality stage in datastage tool?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
