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
- 10910 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 will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How do we call shell scripts from informatica?
How many number of sessions can one group in batches?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are connected or unconnected transformations?
Mention some types of transformation?
What is joiner change?
my source is junk data how will u remove that junk data by using unix please any one replay me
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
what is the size of your data warehousing?
How do you update the records with or without using update strategy?
draw informatica architecture 8.6 ?
What is enterprise data warehousing?
What is dimensional table?
