create a mapping to retrieve the employees who are getting
salary greater than average salary?

Answer Posted / sudheer113

go with this order EXP, AGG, JOINER, FILTER

this will work

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

605


What is the Process to creating lookup transformation in informatica

587


What are the components of Informatica? And what is the purpose of each?

624


How to generate sequence numbers without using the sequence generator transformation?

649


How do you load alternate records into different tables through mapping flow?

1298






What is a pre-defined event and user-defined event?

579


What is data caches/ index caches?

615


What is union transformation in informatica?

701


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2430


How to use pmcmd utility command?

584


What is depict expression change?

621


How to elaborate powercenter integration service?

652


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3513


How to extract sap data using informatica?

607


What are the conditions needed to improve the performance of informatica aggregator transformation?

585