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...

i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?

Answer Posted / upendra

In Informatica mapping we can find source A last record into Target B first record.


SRC-->Rank--> TGT

note:rank transformation edit propertities tab assign bottom=1

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1223


what is the hint? how to use it to reduce the query processing in program?

7982


What all are steps in up gradation of Informatica server?

1096


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4780


Explain in detail about scd type 1 through mapping.

1630


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1383


What is olap (on-line analytical processing?

1112


How do you use reject loader.

2651


What is the Process to creating lookup transformation in informatica

1091


What are the different components of powercenter?

1114


What is an active transformation?

1159


What is update strategy transform?

1165


What is difference between a gateway node and worker node?

1203


What is union transformation?

1017


How to load the data from people soft hrm to people soft erm using informatica?

1068