1.

What do you mean by incremental loading in Informatica?

Answer»

Unlike full data loading, where all data is processed every time the data is loaded, incremental data loading involves loading only selective data (either updated or created new) from the source to the TARGET system. This method provides the following benefits: 

  • ETL (Extract, transform, and load) process overhead can be reduced by selectively loading data, reducing runtime overall.
  • Several factors can lead to an ETL load process failing or CAUSING errors. The likelihood of risk involved is reduced by the selective processing of the data.
  • Data accuracy is PRESERVED in the historical record. Therefore, it BECOMES easy to determine the amount of data processed over time.


Discussion

No Comment Found

Related InterviewSolutions