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
What is the format of informatica objects in a repository?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to configure mapping in informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
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 are some examples of informatica etl programs?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is Cognos script editor?
What is an expression transformation in informatica?
Quickly characterize reusable change?
Where are the source flat files kept before running the session?
How to load last n records of file into target table - informatica
Explain the shared cache and re-cache?
What is mapping debugger?