Assume u have a 24CPU machine with 24GB RAM, suggest how u
would like to configure Informatica ,like number of
concurrent sessions, RAM requirements etc,max partitions
that u would permit per mapping.
- 1 Answers
- 2040 Views
- I also Faced
- E-Mail Answers
Answer / Shivam Nanda
For a 24CPU machine with 24GB RAM, you can configure Informatica as follows:
- Set the number of concurrent sessions to around 12 to 16 based on available resources.
- Allocate sufficient memory (~8 GB per session) to avoid out-of-memory errors.
- Limit the maximum partitions allowed per mapping to 4 to minimize I/O contention and optimize performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
how do u extract data from different data sources explain with an example?
what is HISTOGRAM? how to generate statistics?
What is tracing level?
Is apache nifi an etl tool?
how do u set the size of block buffer?
What are the new features of informatica 9 version?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What are the three tiers in etl?
what are Lookup caches options? Including persistent caches.
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Teradata 
