Interview Questions

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between Stop and Abort - ETL

ETL (extract, transform, and load) Testing Interview Questions


(Continued from previous question...)

13. When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between Stop and Abort - ETL

- Updation of Master Table and Slowly Changing Dimensions (SCD) type 1 utilizes Dynamic cache - Static cache is utilized for flat files

Name 4 output files that Informatica server creates during session running:

1. Session log
2. Badfile
3. Errors log
4. Workflow log

(Continued on next question...)

Other Interview Questions