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 are the basic requirements to join two sources in a source qualifier transformation using default join?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Quickly characterize reusable change?
Explain the aggregator transformation?
Describe an informatica powercenter?
What is Data Caches size?
What is the function of aggregator transformation?
COM components can be used in Informatica
What is informatica? Why do we need it?
What is olap (on-line analytical processing?
how many types of dimensions are available in informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is intricate mapping?
How to generate sequence numbers without using the sequence generator transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?