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

What is the format of informatica objects in a repository?

1022


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1631


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

1909


What are the different transaction levels available in transaction control transformation?

1213


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

1032


How to create the source and target database connections in server manager?

1094


permutations of mapplet

2513


What are the data movement modes in informatica?

1166


Performance tuning( what you did in performance tuning)

1995


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2140


What is the difference between STOP and ABORT options in Workflow Monitor?

1262


How do you load only null records into target? Explain through mapping flow.

2033


What are the prerequisite tasks to achieve the session partition?

1258


Briefly describe lookup transformation?

1047


Explain the difference between a data warehouse and a data mart?

1063