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
Post your comment