create a mapping to retrieve the employees who are getting
salary greater than average salary?
- 4 Answers
- 9271 Views
- TCS, I also Faced
- E-Mail Answers
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
what is informatica metadata?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
can we override a native sql query within informatica? Where do we do it?
What is the meaning of up gradation of repository?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is a passive transformation?
What is fact table? Explain the different kinds of facts.
What is update strategy transform?
How to create or import flat file definition in to the warehouse designer?
What are the different transaction levels available in transaction control transformation?
How can we create index after completion of load process?
Different sorts of metadata that stores in the storage facility?
How to update a particular record in target with out running whole workflow?
Explain scd type 3 through mapping.
What are the different options available for update strategy?
