When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between Stop and Abort - ETL
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
- 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
What is the difference between stop and abort?
Stop:
- The reading process will immediately be killed by using Stop command
- It does not have time out period
Abort:
- It gives a time out period of 60 seconds to the Informatica server.
- Otherwise it kills the DTM process