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 are the different ways to implement parallel processing in informatica?

0 Answers  


Is it possible to create multiple domains on a single Informatica server?

0 Answers  


In ur current projectu have done any performance tuning of mappings?

1 Answers  


which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,


What if the source is a flat-file?

0 Answers  


Differentiate between a database and data warehouse?

0 Answers  


What is a rank transform?

0 Answers  


Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  


i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,


What is workflow? What are the components of workflow manager?

0 Answers  


wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,


In informatica workflow manager, how many repositories can be created?

0 Answers  


Categories