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 |
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
can you use flat file for lookup table?why?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
What does refresh system mean, and what are its distinctive choice?
what are the types of Data warehousing ?
What is confirmed dimension with scenario
what is the process of target load planing?
How many ways are there to create ports?
How can yoU create or import flat file definition in to the warehouse designer?