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
- 10816 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 the need of an ETL tool?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is the need for an etl tool?
How to update or delete the rows in a target, which do not have key fields?
What happens when a session fails and you click on recover?
What all are steps in up gradation of Informatica server?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Quickly characterize reusable change?
What is intricate mapping?
How union transformation is used?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
When do you use sql override in a lookup transformation?
Explain constraint based loading in informatica
Name the different lookup cache(s)?
