whether Sequence generater T/r uses Caches? then what type
of Cache it is
Answer Posted / shiva
multi-caches.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Describe the impact of several join conditions and join order in a joiner transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Can we create multiple integration service on single repository?
What is the way to execute pl/sql script using informatica mapping?
What is the difference between a connected look up and unconnected lookup?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are active and passive transformations?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain load alternative records / rows into multiple targets - informatica
What are pre and post-session shell commands?
How you prepared reports for OLAP?
How to generate sequence numbers without using the sequence generator transformation?
What are the different lookup cache(s)?