How will you recover the ETL Run from the point of failure?

How will you recover the ETL Run from the point of failure?

We can recover the ETL from the point of failure, this is built in Informatica Logics, When ever the Informatica runs Normal Load it maintains Log file, when ever the Mapping is failed andyou want to recover from the point of failure, once you rerun the mapping, informatica reads its log file and re run from the point of failure

for further details Please email training@escalglobal.com, we can Help you with OBIEE 11G Training and provide application support

 

What is the difference between Bulk Load and Normal Load ?

When ever you Populate data from Source to Stage it should run in Bulk Load, Infromatcia Mappings can be run in two ways, Bulk Load and Normal Load, When you do bulk load Informatica pulls lot of rows in one shot, also Disadvantage using bulk load if the Mapping failed, you cannot recover it from the Failed point because it will not have any Logs, IF doing Bulk load we should never have Indexes on Table

Normal Load is Row by Row Processing, means it takes one row from source and writes in Target, we can have index on table when we are running Normal mode

for further detalis Please email to training@escalglobal.com,  We Provide Best Informatica Training with Real time Project