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..........
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
Can you explain players in datastage?
What is the difference between in process and inter process?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How a source file is populated?
If you want to use a same piece of code in different jobs, how will you achieve this?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How to RD using transformer?
What are system variables and sequencers 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?
Difference between in process and inter process?
what is use of SDR function?
What is the purpose of pivot stage and types of containers in datastage
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Have you used Unstructured data?