how much memory (size) occupied by a session at runtime
Answers were Sorted based on User's Feedback
Answer / nandini
12,000,000 bytes of memory to the session.
sorry i made a mistake before
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / srikanth
A session contains mapping and sources, trans, targets in
that mapping. I think the size of session depends on the
caches that we used for diff transformations in mapping and
the size of the data that passes through transformations.
provide me with better ans
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / nandini
Approximately 200,000 bytes of shared memory for each
session slot at runtime.
| Is This Answer Correct ? | 1 Yes | 7 No |
Answer / amit
it ocupied 4gb memori size 2gb for data cache & 2gb for
index cache
| Is This Answer Correct ? | 0 Yes | 8 No |
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
how to return multiple columes through through un-connect lookup?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
Is it possible to create multiple domains on a single Informatica server?
Why we use lookup transformations?
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
How to load a Dimension ? and how to load a fact table?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.