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

Mention a few design and development best practices for informatica?

976


What is native users?

1137


Differences between connected and unconnected lookup?

1201


What is the function of union transformation?

1110


What is the sql query overwrite in source qualifier in informatica

1067


I have a flat file, want to reverse the contents of the flat file

1106


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1888


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1093


Can we create a node as a gateway node and the same node can be assigned to a grid?

1067


Define mapplet?

997


What is a predefined event?

1079


What is the meaning of up gradation of repository?

1957


Explain what are the different types of transformation available in informatica.

1118


whats the logic to load the lower level of granularity of data to fact table.

2254


Explain load alternative records / rows into multiple targets - informatica

1136