create a mapping to retrieve the employees who are getting
salary greater than average salary?
Answer Posted / shrawan
select employee, salary from table_name
where
salary > ( select avg(salary) from table_name;
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What do you mean incremental aggregation?
What are the tasks that can be performed using sq?
How to call shell scripts from informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain sessions?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to use pmcmd utility command?
How do you take back up of repository?
How are indexes created after completing the load process?
Define mapping and session?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what are 3 tech challenges/ common issues you face?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what is degenerated dimension?
How do you load alternate records into different tables through mapping flow?