There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department.
Write a query
- 7 Answers
- 10558 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sameer
Select * from emplyees
Where sal>(select avg ( sal) from emplyees )
No need to write complex queries
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the different lookup cache(s)?
Differentiate between router and filter transformation?
What is flashback table ? Advance thanks
What is the difference between router and filter?
How to convert multiple rows to single row (multiple columns) in informatica
What is primary and backup node?
What is the format of informatica objects in a repository?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How can we use mapping variables in informatica? Where do we use them?
What is domain in terms of informatica?
Please let me know how to make Data masking in informatica..
What are connected or unconnected transformations?
Clarify the aggregator change?
Difference between Target-based loading and constraint-based loading?
