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
- 13212 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
How can we improve the performance in datastage?
Differentiate between hash file and sequential file?
What are the different layers in the information server architecture?
What is the difference between in process and inter process?
Explain ibm infosphere information server and highlight its main features?
What are routines in datastage? Enlist various types of routines.
Distinguish between informatica & datastage. Which one would you choose and why?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Define oconv () and iconv () functions in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
how can we create rank using datastage?what is the meaning of rank?
What is the importance of the exception activity in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How do you import and export the datastage jobs?
What is merge stage?
