Hi Use stage variables in Transformer stage i.e IF THEN ELSE IF ..cond

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..........

Question Posted / sreepathi

3 Answers
9621 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

Please Help Members By Posting Answers For Below Questions

What is the difference between an operational datastage and a data warehouse?

1153

What is ibm datastage flow designer?

1144

What are the types of containers?

1228

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3790

explain about citrix scheduling tool in datastage

2450

How do you schedule or monitoring the job?

1204

What are the types of hashed files in data stage

1106

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1408

What are data elements?

1171

client know skid info?

2079

What is a merge?

1162

If you want to use the same piece of code in different jobs, how will you achieve it?

1152

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2374

What is the difference between odbc and drs stage?

1091