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

What are the different types of olap? Give an example?

1048


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

7808


What are connected or unconnected transformations?

1116


difference between informatica 8.1.1 and 8.6

3673


How to improve the performance of a session using sorter transformation?

1142


How many dimensions are there in informatica?

1077


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

1105


What is the meaning of decode in informatica?

1118


In informatica workflow manager, how many repositories can be created?

1348


have u done any performance tuning? how u ll do?

2293


What is a sequence generator transformation?

1010


How do you promote a non-reusable transformation to reusable transformation?

1132


Whats there in global repository

1689


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1075


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1123