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 am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
What are the uses of a Parameter file?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
What is the default source option for update stratgey transformation?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
Describe an informatica powercenter?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
Whatis the difference between View and Materialized View ?