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
How to join three sources using joiner?
What is the sql query overwrite in source qualifier in informatica
Describe data concatenation?
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 differs when we choose the sorted input for aggregator transformation?
Explain why we use partitioning the session in informatica?
What are the types of data warehouses?
What are the issues you have faced in your project? How did you overcome those issues?
In warehouses how many schemas are there?
What is a joiner transformation?
Explian the Process of deployment groups in informatica
How to do unit testing in informatica?
What are the tuning techniques you applied during your last project
What are mapplets? How is it different from a Reusable Transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?