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 olap (on-line analytical processing?

1009


without table how to come first record only in oracle?

2207


What is a grid in Informatica?

1003


What are the prerequisite tasks to achieve the session partition?

1179


whats the logic to load the lower level of granularity of data to fact table.

2208


Can we override a native sql query within informatica?

989


What is meant by active and passive transformation?

1031


Explain the code page compatibility?

1022


What are the steps involved in the migration from older version to newer version of Informatica Server?

2045


What is a sorter transformation?

1041


Suppose we do not group by on any ports of the aggregator what will be the output?

985


How we can create indexes after completing the loan process?

1146


What are the types of caches in lookup? Explain them.

920


Define filter transformation?

1033


How to Create a folder using pmrep command?

1107