Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9773 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
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the use of hoursfromtime() function in transformer stage in datastage?
How many types of hash files are there?
Where the datastage stored his repository?
On which interface you will be working as a developer?
What are the various kinds of the hash file?
Define Merge?
which r the connectors used in san?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are the different types of lookups in datastage?
Differentiate between operational datastage (ods) and data warehouse?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How complex jobs are implemented in datstage to improve performance?
Define ds designer?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
