whether Sequence generater T/r uses Caches? then what type
of Cache it is

Answers were Sorted based on User's Feedback



whether Sequence generater T/r uses Caches? then what type of Cache it is..

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

whether Sequence generater T/r uses Caches? then what type of Cache it is..

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

whether Sequence generater T/r uses Caches? then what type of Cache it is..

Answer / krishna

also a rank Xmation uses cache

Is This Answer Correct ?    7 Yes 2 No

whether Sequence generater T/r uses Caches? then what type of Cache it is..

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

whether Sequence generater T/r uses Caches? then what type of Cache it is..

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

whether Sequence generater T/r uses Caches? then what type of Cache it is..

Answer / vikas

reusable and non-reusable cache transformation, reusable
will provide unique value for same transformation used in
all sessions.

Is This Answer Correct ?    0 Yes 0 No

whether Sequence generater T/r uses Caches? then what type of Cache it is..

Answer / shiva

multi-caches.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

what is a time dimension? give an example?

2 Answers   IBM,


case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  


how to work with mapplet designer in informatica?

7 Answers  


IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  


Why we use lookup transformations?

1 Answers  


In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,


which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


How do you implement scheduling in Informatica?

1 Answers  


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  


when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  


how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,


Difference Between ETL & ELT?

1 Answers   TCS,


Categories