create a mapping to retrieve the employees who are getting
salary greater than average salary?
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 promote a non-reusable transformation to reusable transformation?
What are the types of lookup transformation?
What is the use of transformation?
list out all the transformations which use cache?
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?
what are 3 tech challenges/ common issues you face?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the different ways to implement parallel processing in informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Is it possible to define a single node as a Gateway node as well as worker node?
How to generate sequence numbers without using the sequence generator transformation?
Explain the types of lookup transformation?
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.
In warehouses how many schemas are there?
Write the advantages of partitioning a session?