If we have lookup table in workflow how do you trouble
shhot to increase performance?
Answer Posted / 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 |
Post New Answer View All Answers
what is the Default Source Option For Update Strategy Transformation?
How do you handle two sessions in Informatica
Describe the impact of several join conditions and join order in a joiner transformation?
I have a flat file, want to reverse the contents of the flat file
expain about the tune parameters?
How to do the error handling of if ur source is flatfiles?
How are indexes created after completing the load process?
What is the Process to creating lookup transformation in informatica
Describe an informatica powercenter?
What is a router transformation?
What is lookup transformation?
what are the Methods For Creating Reusable Transformations?
What is a dimensional model?
pmscmd startworkflow -sv
How to load a Dimension ? and how to load a fact table?