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


Please Help Members By Posting Answers For Below Questions

wat are deployement groups in informatica, how it will be used for developers

1354


Differentiate between reusable transformation and mapplet.

701


How can repository reports be accessed without sql or other transformations?

828


what is the size of your data warehousing?

1762


what is the -ve test case in your project.

1975






How do you load unique records into one target table and duplicate records into a different target table?

828


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1540


what are the Methods For Creating Reusable Transformations?

730


How to implement security measures using repository manager?

695


What do you mean by enterprise data warehousing?

743


Explain the use of aggregator cache file?

799


Slowly changing dimensions, types and where will you use them

1364


Mention some types of transformation?

702


How to do unit testing in informatica?

832


What is a joiner transformation and why it is an active one?

653