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 a table contains 100 records we have to fetch 50-100
records from source to target?how

Answer Posted / imran

use a Sequence Generator T/R........

GO to SG T/r-->Properties (Set the values as shown below)--->

1) 'Enable' the Cycle Option
2) give 'Start value' as 50
3)End Vale 100
4) Increment BY 1
5) Connect Nextval & Currval o/p ports to Target

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert multiple rows to single row (multiple columns) in informatica

1384


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9827


where to store informatica rejected data? How to extract the informatica rejected data?

1007


How to do unit testing in informatica? How to load data in informatica ?

1123


How can you validate all mappings in the repository simultaneously?

1372


What is the need of an ETL tool?

1103


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2361


Why do we need informatica?

998


What is parallel processing in informatica?

1718


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2361


Explain sql transformation in script mode examples in informatica

1139


What are the tuning techniques you applied during your last project

2027


What is domain and gateway node?

1167


Explain where to store informatica rejected data? How to extract the informatica rejected data?

1015


Differentiate between a database and data warehouse?

1147