If we have lookup table in workflow how do you trouble
shhot to increase performance?
Answers were Sorted based on User's Feedback
Answer / deepak aggarwal
You can calculate the size of lookup cache file needed
from number of rows and colulmn width needed. You can
increase Cache file size for good performance.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / priya
There are 2 ways :
1. Create a persistant cache
2. Add the lookup table in SQ make it outer joined
Is This Answer Correct ? | 1 Yes | 0 No |
 Code page compatibly –Where all changes are made to handle the scenario.
How do you take back up of repository?
How to improve the session performance in informatica?
why do we go for update strategy tr in SCD rather using the session properties?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
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?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
what is diffrence b/w joner and union transfermation
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
what are the settiings that u use to cofigure the joiner transformation?