how much memory (size) occupied by a session at runtime

Question Posted / guest

4 Answers
12757 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how much memory (size) occupied by a session at runtime..

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

how much memory (size) occupied by a session at runtime..

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

how much memory (size) occupied by a session at runtime..

Answer / nandini

Approximately 200,000 bytes of shared memory for each
session slot at runtime.

Is This Answer Correct ?

1 Yes

7 No

how much memory (size) occupied by a session at runtime..

Answer / amit

it ocupied 4gb memori size 2gb for data cache & 2gb for
index cache

Is This Answer Correct ?

0 Yes

8 No

Post New Answer

More Informatica Interview Questions

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers Amdocs,

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers BirlaSoft,

how to insert header after each group.

1 Answers IBM,

Does Facttable Normalized or Denormalized?

2 Answers IBM,

If I am having 6 flat files in data. How can you load the data at a time

2 Answers CSC,

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers

Mapplets can you use an active transformation in a mapplet,

1 Answers

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?