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

Where are the source flat files kept before running the session?

634


Define mapplet?

634


Explain sessions. Explain how batches are used to combine executions?

604


What is difference between a gateway node and worker node?

637


if we have a delimiters at unwanted places in a flat file how can we over come those.

1576






Mention some types of transformation?

612


What are pre and post-session shell commands?

751


What are the different lookup cache(s)?

630


Write the different tools in the workflow manager?

582


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2147


Why is sorter an active transformation?

672


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

718


What is the status code in stored procedure transformation?

693


How can one identify whether mapping is correct or not without connecting session?

899


Explain the different dimensions.

566