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
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
What is informatica?
what is degenerated dimension?
Enlist the tasks for which source qualifier transformation is used.
What is Session and Batches?
What are the components of the workflow manager?
Informatica settings are available in which file?
What is meant by a domain?
What is decode in informatica?
What are the types of lookup transformation?
Describe data concatenation?
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 ?
What is the sql query overwrite in source qualifier in informatica
Design a mapping to load a target table with the following values from the above source?
What are the reusable transformations?