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

what is SDLC way of code development?

2091


What are the components of Informatica? And what is the purpose of each?

1108


Explain the shared cache and re-cache?

1165


What is data caches/ index caches?

1172


What is union transformation in informatica?

1192


Different circumstance which drives informatica server to expel records?

1041


Where is metadata stored?

1193


Explain the types of lookup transformation?

1105


How do you load first and last records into target table?

1209


What are data-driven sessions?

1261


What is sq transformation?

1231


What is the difference between router and filter?

1372


What is olap (on-line analytical processing?

1110


What is informatica metadata and where is it stored?

1043


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4150