Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  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 the facts will be loaded? explain

2 Answers   HCL,

What are the phases in SDLC?

3 Answers  

Explain in detail scd type 2 through mapping.

0 Answers  

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  




Mention few power centre client applications with their basic purpose?

0 Answers  

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

waht is dataware house

2 Answers  

For more Informatica Interview Questions Click Here




Categories