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 the maplet?

0 Answers   Informatica,


what is the dashbords?

1 Answers   IBM,


What is workflow manager?

0 Answers  


I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,


How are indexes created after completing the load process?

0 Answers  






Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,


How union transformation is active ?

2 Answers   Puma,


Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  


what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,


how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,


my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,


how to run the batch using pmcmd command

2 Answers   Wipro,


Categories