GeekInterview.com
Series: Subject: Topic:
Question: 744 of 1131

what is incremental loading in informatica(that is used to load only updated information in the source)?how and where u use it in informatica?

Asked by: amark123 | Member Since Aug-2006 | Asked on: Aug 23rd, 2006

View all questions by amark123

Showing Answers 1 - 3 of 3 Answers

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.

  
Login to rate this answer.
Rangini vignesh

Answered On : 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.

  
Login to rate this answer.
rsannu2k

Answered On : Jun 7th, 2007

View all answers by rsannu2k

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?

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.