Interested to Buy Any Domain ? << Click Here >> for more details...
create a mapping to retrieve the employees who are getting
salary greater than average salary?
- 4 Answers
- 10738 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
Enterprise data warehouse your projects phase by phase explain?
What is joiner transformation?
update strategy transformation in informatica
what is the difference between informatica6.1 and infomatica7.1
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the difference between informatica 7.0 and 8.0?
What is the use of source qualifier?
What is dimensional table? Explain the different dimensions.
tell me the rules and responsblites in our project(my project is development)
What are ETL Tools?
What is the way to execute pl/sql script using informatica mapping?
Enlist the advantages of informatica.
define galaxy repository in informatica
What is meant by active and passive transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
