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
- 11158 Views
- TCS, I also Faced
- E-Mail Answers
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 is olap (on-line analytical processing?
Tell me about MD5 functions in informatica
How to do unit testing in informatica?
How can you differentiate between powercenter and power map?
What are the differences between oltp and olap?
How can we update a record in the target table without using update strategy?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How many transformations can be used in mapplets.
What is a predefined event?
have u done any performance tuning? how u ll do?
Explain the scenario which compels informatica server to reject files?
What are the advantages of using informatica as an etl tool over teradata?
How do you change a non-reusable transformation to reusable transformation?
What could be the possible resons of locks by user?
