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 |
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to handle decimal places while importing a flatfile into informatica?
If we are using an aggregator but forget to mention the group by port .what will be the output??
Where can we find the throughput option in informatica?
How can you join two tables without any common column present in them?
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
How many input parameters can exist in an unconnected lookup?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the difference between a router and a filter transformation?
Name the different lookup cache(s)?