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

Differentiate between router and filter transformation?

1063


Difference between Target-based loading and constraint-based loading?

1042


How can you define user defied event?

1073


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2300


What is a sequence generator transformation?

1072


How can we handle two sessions in informatica?

1092


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1129


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2103


complex mapping ur project u r invlve can u explain and give real time example give me ?

2348


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2186


my source is junk data how will u remove that junk data by using unix please any one replay me

3755


What's the layout of parameter file (what does a parameter file contain?)?

2434


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

1141


Can we change Dynamic to Static or Persistent cache? If so what happens?

2248


What are the differences between oltp and olap?

1017