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
- 10994 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
How can we use batches?
What is expression transformation?
Enlist few areas or real-time situations where informatica is required.
Explain the types of transformations?
How to extract sap data using informatica? What is abap? What are idocs?
How many number of sessions can one group in batches?
What is the difference between writing a joiner query in ANSI style and THETA style?
Describe an informatica powercenter?
How can you increase the performance in joiner transformation?
How can we delete duplicate rows from flat files?
define galaxy repository in informatica
Explain Dataware house architecture .how data flow from intial to end?
Explain sql transformation in script mode examples in informatica
r u done any partitions in ur project?
Why is sorter an active transformation?
