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 use incremental load?

Answer Posted / moorthy g

Source --->SQ ----> Expression ---> Target

===> Create Mapping Variable
===> In SQ use sql override
where startdate < $$date

====> In expression use variable port,
setmaxvariable($$date, startdate)
=====================================
You can find variable value in Log fine and session RC you
can find it.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create two repositories on same database instance in oracle?

1093


What is the sql query overwrite in source qualifier in informatica

1090


Why sorter is an active transformation?

1192


If informatica has its scheduler why using third party scheduler?

1268


How we can create indexes after completing the load process?

1160


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2262


What are active and passive transformations?

1082


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2036


What is informatica etl tool?

1000


Explain the different kinds of facts.

981


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1085


What are the limitations of joiner transformation?

1114


Difference between Data and Index Caches?

1137


What is meant by incremental aggregation?

1106


How to Create a folder using pmrep command?

1174