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 Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Explain the different dimensions.
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
How to load data in informatica ?
what is the incremental agrrigation?
What does role playing dimension mean?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is the difference between mapplet & stored procedure?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What do you mean by blocking transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?