satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Aug 28th, 2006

 

hi friend,

you got it correctly.

incremental loading is loading updating old rows and inserting newly arrived rows.

for this we use UpdateStrategy transformation.

In each and every real time datawarehouse project this incremental loading is important. so UpdateStrategy as well.

if you want detail inf on UpdateStrategy refer to the answer i gave to one question on UpdateStrategy.

Rangini vignesh

• Aug 30th, 2006

 

The above answer is slightly correct.

The incremental loading is done in 3 ways by using Transformations.

1.Aggregate Transformation,

2.Dynamic Lookup Transformation,

3.Update Strategy Transformation,

In the mapping we can use either Aggregate Transformation or Dynamic Lookup Transformation with Updatestrategy or filter  Transformtion for performing update or insert the newly captured records.

Session level in the property tab in the performane have option like "incremantal Aggragetion".If  u enable this property the seession captures only newly records from the source.

rsannu2k

 Profile Answers by rsannu2k 

• Jun 7th, 2007

 

Rangini,

Incremental Aggregations, I think informatica provides this feature to load the sessions which are abruptly termination in middle of the load, am I right? also I would like to know how you can use Aggregator Transformation to load incrementally? I only know this we use to group some columns to come up with aggregate data?