How to improve the session performance in informatica?
- 3 Answers
- 20392 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vinay kumar
set properties of mapping tab set bulk loading option in sesstion then performs is increasng..........but sometimes session is failed, the session is no reusable
tht is an drawback
| Is This Answer Correct ? | 5 Yes | 0 No |
Explain your project of banking domian.
What do mean by local and global repository?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Define Incremental Aggregation?
What are different types of transformations available in informatica?
What are the new features of the server manager in the informatica 5.0?
What is data caches/ index caches?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
How many dimensions are there in informatica?
in which situations do u go for starflake schema ?
can we use cartesian join in informatica
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
Teradata 
