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
- 9771 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
To see hidden files in LINIX?
Explain the importance of surrogate key in data warehousing?
Can you explain link buffering?
What are transforms and what is the differenece between routines and transforms?
Define Routines and their types?
what are the errors,warnings in datastage
Define project in datastage?
Does datastage support slowly changing dimensions ?
How to reverse the string using SQL?
How many areas for files does datastage have?
How can one find bugs in job sequence?
Define meta stage?
What is the difference between passive stage and active stage?
What are the steps required to kill the job in Datastage?
What are the functionalities of link partitioner and link collector?
