whether Sequence generater T/r uses Caches? then what type
of Cache it is
Answer Posted / 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 |
Post New Answer View All Answers
What are multi-group transformations?
Why sorter is an active transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the different types of transformation available in informatica.
Can you generate sequence numbers without using the sequence generator transformation?
Explain why we use partitioning the session in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is blocking transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the types of schemas we have in data warehouse and what are the difference between them?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Quickly characterize reusable change?
What are the various types of transformation?