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

Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?

Answer Posted / sri

For this you can write SQL query by TOP clause in expression
transformation.
Or else You can use Rank Transformation.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1464


Sequence generator, when you move from develoment to production how will you reset

2126


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2481


Explain the features of connected and unconnected lookup.

975


What are Dimensional table?

1120


What are the new features of informatica 9.x at the developer level?

1105


Is it possible to define a single node as a Gateway node as well as worker node?

1186


write a query to retrieve the latest records from the table sorted by version(scd)

1122


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1847


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7184


draw informatica architecture 8.6 ?

3931


What is meant by a domain?

1189


Explain the use of aggregator cache file?

1317


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2030


In warehouses how many schemas are there?

1130