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
- 13495 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
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
how to delete one row in target dataset
What are orabulk and bcp stages?
describe the Steps to confiure a Qlogic switch
Distinguish between informatica & datastage. Which one would you choose and why?
How to find value from a column in a dataset?
What are stage variables?
How many types of sorting methods are available in datastage?
What are datastage sequences?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the differences between datastage and informatica?
What is a merge?
State the difference between an operational datastage and a data warehouse?
How will you move hashed file from one location to another location?
