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
- 10739 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sudheer113
go with this order EXP, AGG, JOINER, FILTER
this will work
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you load alternate records into different tables through mapping flow?
How to handle decimal places while importing a flatfile into informatica?
How do you update the records with or without using update strategy?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the transformations that are not supported in mapplet?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Write the unconnected lookup syntax and how to return more than one column.
What all join we can perform in LOOKUP transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Which transformation should we use to normalise the COBOL and relational sources?
What are the different options available for update strategy?
Which transformation is needed while using the Cobol sources as source definitions?
What is lookup transformation?
How do you use reject loader.
