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 is aggregate cache in aggregator transforamtion?
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
Is there any model difference between ODS and DWH
what is sql override?what is the use of it?
When you move from devel to prod how will you retain a variable
Whats there in global repository
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
what is the method of error handling when session is running?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
What are pre and post-session shell commands?
Can anyone tell me the new features in Informatica 9 Version?