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
- 10984 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
How union transformation is used?
How to join three sources using joiner? Explain though mapping flow.
What is decode in informatica?
What are active transformations.
Explain the etl program with few examples.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How can we use batches?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is a rank transform?
What is a router transformation?
On which transformations you created partitions in your project?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How do you handle two sessions in Informatica
How we can use union transformation?
