follwing scenario two table using find maximum salary?
table a table b
101 xxx 1000 106 6500
103 yyy 5000 108 800
104 din 6000 109 7000
105 dsh 200 110 3000
Answer Posted / ankit kansal
Using Informaica
src-->>sq-->>rnk(sal,bottom,1)
-->>union-->>tgt
src-->>sq-->>rnk(sal,bottom,1)
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do mean by local and global repository?
What are the limitations of joiner transformation?
How do you load only null records into target? Explain through mapping flow.
How to load a Dimension ? and how to load a fact table?
How can informatica be used for an organization?
Difference between Data and Index Caches?
Design a mapping to load a target table with the following values from the above source?
What is informatica etl tool?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is meant by target load plan?
How to partition the Session?
Explain the shared cache and re-cache?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
To import the flat file definition into the designer where should the flat file be placed?
What is persistent lookup cache?