[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.
Technical Discussion :: Informatica

4 / 94

How do you improve the performance of lookup transformation?

Answer:

If the lookup table is on the same database as the source table in your mapping and caching is not feasible, join the tables in the source database rather than using a Lookup transformation.
If you use a Lookup transformation, perform the following tasks to increase performance:
  • Use the optimal database driver.
  • Cache lookup tables.
  • Optimize the lookup condition.
  • Filter lookup rows.
  • Index the lookup table.
  • Optimize multiple lookups.
  • Create a pipeline Lookup transformation and configure partitions in the pipeline that builds the lookup source.

Asked In ::

Post Your Answer Here:


Rate This: +0 -0     
Report    

Post Your Reply Here:

Alert me
q4i-reply-your-answer

Report Error

Please Login First Click Here

Most Popular Qs.