source has 2 fields like
COMPANY LOCATION
IBM HYD
TCS BAN
IBM CHE
HCL HYD
TCS CHE
IBM BAN
HCL BAN
HCL CHE
LIKE THIS.......
AND I WILL GET THE OUTPUT LIKE THIS....
Company loc count
TCS HYD 3
BAN
CHE
IBM HYD 3
BAN
CHE
HCL HYD 3
BAN
CHE
PLZ SEND ME ANSWER FOR THIS QUESTION..........
- 3 Answers
- 8457 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / solomon
2 ways to do it
1- input -> Transformer -> RDP-> output
Sort the input on location, company
do a comparison in Stage Variable with prev record and keep incrementing a counter
pass it via Remove duplicate stage to retain unique records
2- input-> copy-> agrregator-> lookup-> RDP -> output
do the same as above using agg and lookup stage
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Triggers,VIEW,Procedures
Why do we use link partitioner and link collector in datastage?
Describe the architecture of datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Define repository tables in datastage?
Can you explain kafka connector?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are sequencers?
What is orabulk stage?
What is the difference between odbc and drs stage?
What are the components of datastage?
What all are the different way to run a job?
What are the different common services in datastage?
How do you import and export the datastage jobs?
