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 the status code in stored procedure transformation?
What is the default source option for update stratgey transformation?
Two Default User groups created in the repository are ____ and ______
What is decode in static cache?
How many numbers of sessions can one group in batches?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
What does cheating measurement mean?
how to get the only updated records in the target
what is diff between IN and EXIT commands
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
what is the difference between informatica6.1 and infomatica7.1
Different sorts of metadata that stores in the storage facility?