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

How many types of hash files are there?

1117

Name the different sorting methods in datastage.

989

Is it possible to query a hash file?

1951

How to Remove Duplicate using SQL?

1290

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2005

what is use of SDR function?

5127

What are the different type of jobs in datastage?

1002

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1137

How to manage date conversion in Datastage?

1069

What are the types of containers and how to create them?

931

What are the repository tables in datastage?

1257

What is the command line function to import and export the ds jobs?

1096

What is meta stage?

1131

Define ds designer?

1216

how to write server Routine coding?

2061