What are the Differences between static cache and dynamic cache?
Answer / 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 |
write a query to retrieve the latest records from the table sorted by version(scd)
What is meant by incremental aggregation?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
what is the monster dimension plz give me one example
What are the scheduling options to run a sesion?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
How to use Normalizer transformation?
What are batches?
explain different types of modeling.
how to get flatfile containg 10 records half records one target another half another target
If we set dd_insert in mapping and Delete in session properties what will happen.?
how can we check whether a particular cache is static or dynamic?