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 might you approve all mappings in the archive all the while?

1016


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1081


What are mapplets?

1264


How to do unit testing in informatica?

1167


Describe data concatenation?

1073


What is event and what are the tasks related to it?

1118


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

1005


How does a rank transform differ from aggregator transform functions max and min?

1200


What is mapping debugger?

1009


What are the new features of Power Center 5.0?

1770


What is domain in terms of informatica?

1000


Explain target update override in informatica

1122


In warehouses how many schemas are there?

1070


Explain the types of lookup transformation?

1041


Write the unconnected lookup syntax?

1080