Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the session performance in informatica?
- 3 Answers
- 21510 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / gyana ranjan behera
SESSION LEVEL PERFORMANCE TUNING
(1)SET YOUR SESSION TO RUN IN BULK MODE
(2)DO SESSION PARTITION
(3)INCREASE COMMIT INTERVALS
(4)CHECK THE INCREMENTAL AGGREGATION
(5)DTM BUFFER SIZE MUST BE IN BETWEEN 6MB TO 128MB
(6)BUFFER BLOCK SIZE 4KB TO 128KB
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
State the limitations where we cannot use joiner in the mapping pipeline?
What is expression transformation?
How is union transformation utilized?
How can we use mapping variables in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the cumulative sum and moving sum?
Parameter and variable differences
What are the types of schemas we have in data warehouse.
What is the procedure for creating independent data marts from informatica 7.1?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the benefit of partitioning a session?
What do you understand by term role-playing dimension?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
