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 are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what are the deliverables?in your project?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Briefly describe lookup transformation?
Explain pushdown optimization and types in informatica
In warehouses how many schemas are there?
While migrating the data from one environment to another environment how would you manage the connections?
What are junk dimensions?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is deployment group?
Explain what are the different types of transformation available in informatica.
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?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
State the differences between sql override and lookup override?
Can anyone tell me the new features in Informatica 9 Version?