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
- 9637 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / sreepathi
Hi
Use stage variables in Transformer stage i.e IF THEN ELSE
IF ..condition comparing companies and use COUNT() function
in transformer for which field u want count
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
how can we create rank using datastage?what is the meaning of rank?
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?
Define data aggregation?
what is use of SDR function?
How do you start developing a datastage project?
how many rows sorted in sort stage by default in server jobs
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are the benefits of datastage?
What are routines in datastage? Enlist various types of routines.
What are the stages in datastage?
What are some prerequisites for datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How rejected rows are managed in datastage?
Define APT_CONFIG in Datastage?
