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 / 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
What can we do with datastage director?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Triggers,VIEW,Procedures
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are some different alternative commands associated with "dsjob"?
What are the different options associated with dsjob command?
What are stage variables and constants?
State the difference between an operational datastage and a data warehouse?
What is size of a transaction and an array means in a datastage?
Can you implement SCD2 using join, transformer and funnel stage?
What is "fatal error/rdbms code 3996" error?
How do you start developing a datastage project?
Give an idea of system variables.
Explain the importance of surrogate key in data warehousing?
What is merge stage?