What are the Differences between static cache and dynamic cache?
Answer Posted / swetha
Static cache
Dynamic cache
U can not inert or update the cache. yoU
can insert rows into the cache as u pass
to the target
The informatic server returns a value from The
informatic server inserts rows into cache
the lookup table opr cache when the condition when the
condition is false.This indicates that
is true. When the condition is not true, the
the row is not in the cache or target table.
informatica server returns the default value yoU
can pass these rows to the target table.
for connected transformations and null for
unconnected transformations.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
can anyone suggest best free Talend data integration training online
What are the features of complex mapping?
Define sessions in informatica etl?
what is song in infrmatica...?
What is rank transform?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the Process to creating lookup transformation in informatica
Define pmcmd command?
What is data movement mode in Informatica and difference between them?
Describe the impact of several join conditions and join order in a joiner transformation?
How many input parameters can exist in an unconnected lookup?
Define joiner transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is an unconnected transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?