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
- 12963 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
Job Design:
Agg--->Filter1---------->|
| | Unique
file-->cp-------------------->Join---->Filter2---->target1
|
|-->Duplicate
Target2
Agg: use aggregator and select Agg_type=count rows and then give the Count O/P column=Cnt (User defined).
Filter1: give the condition Where=Cnt=1
U will get unique values like 200,400,500,600
Use Join (Or) Lookup stage: select left outer join
Filter2:
Where=Column_name='' (Duplicate values like 100,100,300,300,300)
Where=Column_name<>'' (Unique Values like 200,400,500,600)
u will get the right output....what ever the duplicate records.
Plz correct me if am wrong.....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Distinguish between informatica & datastage. Which one would you choose and why?
How many types of sorting methods are available in datastage?
What is the roundrobin collector?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How can one find bugs in job sequence?
Nls stands for what in datastage?
What is the difference between passive stage and active stage?
sed,awk,head
Lookup constraints
Describe the main features of datastage?
What are data elements?
On which interface you will be working as a developer?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What can we do with datastage director?
How do you remove duplicate values in datastage?
