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 ETL Tools?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
Different types of Power center errors?
What is a snowflake schema?
what are the types of Data warehousing ?
Why do we need informatica?
What are the basic needs to join two sources in a source qualifier?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
What are the reusable transforamtions?