The differences between ELT and a traditional ETL process are more significant than just switching the L and the T. The biggest determinant is how, when and where the data transformations are performed. With ETL
- Informatica uses the source data row-by-row to process the data with different transformation models. - Every row that is used in the model by default allows the insertion of the data in the target table. The options available for update strategy are as follows: - DD_INSERT: this option...
What are the different lookup cache(s)? - Informatica provides the lookup cache and un-cache for the static or dynamic types of applications. - The types are defined as follows: - Static caches are those caches that don’t modify the cache when the build of it already being done. The c...
The differences between ELT and a traditional ETL process are more significant than just switching the L and the T. The biggest determinant is how, when and where the data transformations are performed. With ETL, the raw data is not available in the data warehouse because it is transformed be...