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
Where are the source flat files kept before running the session?
Define mapplet?
Explain sessions. Explain how batches are used to combine executions?
What is difference between a gateway node and worker node?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Mention some types of transformation?
What are pre and post-session shell commands?
What are the different lookup cache(s)?
Write the different tools in the workflow manager?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Why is sorter an active transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the status code in stored procedure transformation?
How can one identify whether mapping is correct or not without connecting session?
Explain the different dimensions.