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

Answer Posted / shaik

Source--->EXP--->AGG--->Filter--->Target

by using agg T/f you can find the avg,use that value ti
filter the values by using filter transformation..............

Is This Answer Correct ?    4 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is INFORMATICA TESTING process

1844


Explian the Process of deployment groups in informatica

659


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

601


in reporting we add some new objects,how we get the count of the newly added objects to the report

1753


Briefly explain the aggregator transformation?

601






Explain informatica architecture - version 8 / 9

671


What are the issues you have faced in your project? How did you overcome those issues?

1915


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1562


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1697


What is lookup change?

620


What is the meaning of up gradation of repository?

1391


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1644


What do you mean by blocking transformation?

585


What is blocking transformation?

722


Explain the types of lookup transformation?

577