Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What do mean by local and global repository?

1204


What are the limitations of joiner transformation?

1093


How do you load only null records into target? Explain through mapping flow.

2004


How to load a Dimension ? and how to load a fact table?

1406


How can informatica be used for an organization?

1200


Difference between Data and Index Caches?

1127


Design a mapping to load a target table with the following values from the above source?

1327


What is informatica etl tool?

990


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

2506


What is meant by target load plan?

952


How to partition the Session?

1092


Explain the shared cache and re-cache?

1099


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

1098


To import the flat file definition into the designer where should the flat file be placed?

1046


What is persistent lookup cache?

1017