Answer Detail: RE: Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing maximum sum(salary) group by dept.sources are cobol files / flat files.

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Print |

Question: Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing maximum sum(salary) group by dept.
sources are cobol files / flat files.

Answer: This is the recent question faced in ibm.

October 10, 2008 16:04:07	#3
Mamta11	Member Since: July 2008 Total Comments: 12
RE: Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing maximum sum(salary) group by dept.sources are cobol files / flat files.
This can be done in informatica mappinsg by using the Aggrgator transformation. Select all the ports from source qualifier joining on departmetn into aggregator . Group by departmetn no and select max(salary)

Back To Question