whether Sequence generater T/r uses Caches? then what type
of Cache it is
Answers were Sorted based on User's Feedback
Answer / sree
no it won't have any cache
we have caches for the following t/r
aggregate t/r
joiner t/r
sorter t/r
lookup t/r
| Is This Answer Correct ? | 17 Yes | 5 No |
Answer / anup
the seq t/r uses index cache for the sequential range of
numbers for the generated keys.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / chaitanya
Yes sequence generator uses Cache in case of reusable.
This cache is used to buffer the max no of seq no that can
be generated for each execution.
For more details plz refer Informatic 8.1 manual.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / amir jalali
Sequence generator uses a cache when reusable.
This option is to facilitate multiple sessions that are
using the same reusable sequence generator.
The number of values cached can be set in the properties of
the sequence generator.
Not sure about the type of Cache.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are different types of transformations available in informatica?
What is informatica?
What is a command that used to run a batch?
What are the informatica performance improvement tips
what is diff between grep and find
how to remove staging area
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what is the process of target load planing?
How to improve the performance of Aggregate transformation?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
Where do we use mapping variables in informatica?
What does reusable transformation mean?