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
- 9638 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
Lookup constraints
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is merge stage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the various kinds of the hash file?
What are routines in datastage?
What are the job parameters?
What are transforms and what is the differenece between routines and transforms?
In Datastage, how you can fix the truncated data error?
What is a merge in datastage?
Define repository tables in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
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 one source columns or rows to be loaded in to two different tables?
Describe routines in datastage? Enlist various types of routines.
