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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1659


What is informatica?

809


what is degenerated dimension?

3360


Enlist the tasks for which source qualifier transformation is used.

693


What is Session and Batches?

798






What are the components of the workflow manager?

788


Informatica settings are available in which file?

701


What is meant by a domain?

780


What is decode in informatica?

764


What are the types of lookup transformation?

759


Describe data concatenation?

695


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1323


What is the sql query overwrite in source qualifier in informatica

747


Design a mapping to load a target table with the following values from the above source?

1012


What are the reusable transformations?

813