create a mapping to retrieve the employees who are getting
salary greater than average salary?
Answer Posted / maxy
I think it's better to have a null check here in the exp
before aggregating.
If salary is Null for any employee it will not be consider
while caculating the avg.
ex-
epm sal
e1 10
e2 20
e3
e4 30
Though there are four employee avg will be 20.
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How can informatica be used for an organization?
Explain what are the different versions of informatica?
how to create user defined function (udf) in informatica
How union transformation is used?
What are session parameters ? How do you set them?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What is a mapplet/worklet in informatica?
What are the advantages of informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is target designer and target load order?
Explain the use of aggregator cache file?
Difference between Target-based loading and constraint-based loading?
What are batches?