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

Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve

Answer Posted / praveen hattikal

src---->sq---->exp1--->filter---->exp2---->tgt
sequence gen---^

create mapping variable $run=1000/ in exp2 $run=$run+1000

in filter sequence <$run

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist few areas or real-time situations where informatica is required.

1019


What is the status code in stored procedure transformation?

1119


What differs when we choose the sorted input for aggregator transformation?

967


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

2147


What are the modules in Power Center

1621


What is the commit type if you have a transaction control transformation in the mapping?

969


What are the various types of transformation?

1094


What are the different components of powercenter?

986


Define sessions in informatica etl?

970


What are the differences between oltp and olap?

921


What is informatica?

1077


What is different between the data warehouse and data mart?

1001


What is lookup transformation?

1002


How would you copy the content of one repository to another repository?

949


Implementation methodology

1654