1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / krishnas1978

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

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

What is the advantage of informatica?

0 Answers  

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,




Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

What is primary and backup node?

0 Answers  

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

What is different between the data warehouse and data mart?

0 Answers  

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories