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

If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?

Answer Posted / venkateshmalneni

Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target

src--->sq---> expression--->filter--->target

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to differentiate between the active and passive transformations?

1135


Whats the difference between informatica powercenter server, repositoryserver and repository?

1158


what is the complex transformation you used in informatica

2573


Explain sessions and how many types of sessions are there?

983


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

1885


What is informatica metadata and where is it stored?

977


What are the different types of transformation available in informatica.

1079


is it possible to index the data in cache of lkp transformation ?

2014


how to load rows into fact table in data warehouse

1156


How can a transformation be made reusable?

1136


How many ways are there to do 'remove duplicate records in informatica'?

986


Explain how to import oracle sequence into informatica?

983


How do you load alternate records into different tables through mapping flow?

1833


What is Session and Batches?

1081


How to elaborate powercenter integration service?

1110