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
wat are deployement groups in informatica, how it will be used for developers
Differentiate between reusable transformation and mapplet.
How can repository reports be accessed without sql or other transformations?
what is the size of your data warehousing?
what is the -ve test case in your project.
How do you load unique records into one target table and duplicate records into a different target table?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
what are the Methods For Creating Reusable Transformations?
How to implement security measures using repository manager?
What do you mean by enterprise data warehousing?
Explain the use of aggregator cache file?
Slowly changing dimensions, types and where will you use them
Mention some types of transformation?
How to do unit testing in informatica?
What is a joiner transformation and why it is an active one?