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

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

Answer Posted / triveni

source->sq->sequencegenerato->expression->filter->target
nextval to expressiontransformation
seq(output) decimal 10 nextval
startval=1,endvalue=14,cycle
mapping variable:$$var varible integer 10 o max
intialvalue=0
filter decimal 10
setvariable( $$seq,($$seq+1))

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Different qualification between a related rotate toward the sky and isolates look upward?

929


What is the function of aggregator transformation?

1016


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2389


How can we use mapping variables in informatica? Where do we use them?

1099


How are indexes created after completing the load process?

1545


What is enterprise data warehousing?

987


Enterprise data warehouse your projects phase by phase explain?

1856


What are the different versions of informatica?

1183


Define Pmrep command?

996


What are the prerequisite tasks to achieve the session partition?

1177


How we can use union transformation?

989


During the running session, output files are created by informatica server. Enlist few of them.

930


What is DR strategy for Informatica project?

1114


Differentiate between sessions and batches?

963


How to create or import flat file definition in to the warehouse designer?

1021