Informatica INTERVIEW QUESTION & ANSWERS
71. |
What are the types of cache? |
|
- Static cache
- Dynamic cache
- Persistent cache
- Recache from lookup
- Shared cache
|
72. |
What are the costly transformation in informatica? |
|
- L : Look up
- A : Aggregator
- R : Rank
- J : Joiner
|
73. |
What are the transformation having cache concept? |
|
- Data Cache - 2GB
- Index Cache - 1GB
|
74. |
How does the recovery mode work in informatica? |
|
In case of load failure an entry is made in OPB_SERV_ENTRY(?) table from where the extent of loading can be determined. |
75. |
What is a command that used to run a batch? |
|
pmcmd is used to start a batch. |