Informatica - Calculate max value of a column

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 298 of 305

Calculate max value of a column

How to calculate max value of a column without using aggregrator transformation?

Total Answers and Comments: 3

Last Update: September 01, 2008 Asked by: riteshpathak10

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 23, 2008 06:55:30

narasimha.inf

Member Since: June 2008 Contribution: 1

RE: Calculate max value of a column

max(sal)

Is this answer useful? Yes | No

July 01, 2008 07:58:10

adilshariff

Member Since: June 2008 Contribution: 7

RE: Calculate max value of a column

Use max(Value) in expression transformastion

Is this answer useful? Yes | No

0 1

Overall Rating: -1

September 01, 2008 07:49:26

jryan999

Member Since: April 2008 Contribution: 15

RE: Calculate max value of a column

You need to feed your ports through an Aggregator Tranformation. eg.

Input = salary. Not output
Output = maximum_salary --> max(salary) - Output

Connect the maximum_salary fields to the output to use it
Define other keys as "Group by" as needed.

You cannot use max(salary) function in expression - it only works on a single row

Is this answer useful? Yes | No

Go To Top