whether Sequence generater T/r uses Caches? then what type
of Cache it is
Answers were Sorted based on User's Feedback
Answer / sree
no it won't have any cache
we have caches for the following t/r
|Is This Answer Correct ?||17 Yes||5 No|
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|
Answer / krishna
also a rank Xmation uses cache
|Is This Answer Correct ?||7 Yes||2 No|
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|
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|
Answer / shiva
|Is This Answer Correct ?||0 Yes||2 No|
How the facts will be loaded? explain
What are the phases in SDLC?
Explain in detail scd type 2 through mapping.
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????
SO many times i saw "$PM parser error " .what is meant by PM?
Mention few power centre client applications with their basic purpose?
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
What are set operators in Oracle
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?
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?
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 .
waht is dataware house