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

how can we load starting with 11th record of a table from
source to target

Answer Posted / akash

This scenario can also be implemented by using the
following query in Source Qualifier:

select * from table_name where rowid not in (select rowid
from table_name where rownum <= 10)

This will give the records after 10

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2688


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1057


Is it possible to use a client with different version than that of its Informatica server?

1075


What do you mean by worklet?

1017


Write the program through which the records can be updated?

936


What is mapplet in informatica?

982


explain abt ur project architecture?

2122


What all are steps in up gradation of Informatica server?

988


Where can we find the throughput option in informatica?

996


Can we get 1st record through Informatica(without sequence number).

1406


How to load last n records of file into target table - informatica

1019


If informatica has its scheduler why using third party scheduler?

1193


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2313


What are the main features of Oracle 8i with context to datawarehouse?

2052


Mention few power centre client applications with their basic purpose?

891