performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Answer Posted / soujanya
before cache joiner after cache lookup
| Is This Answer Correct ? | 4 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 does command task mean?
How to go to the older version for a mapping?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What can we do to improve the performance of informatica aggregator transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is resilience time?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is powercenter on grid?
What are mapplets?
What is the difference between source qualifier transformations source filter to filter transformation?
State the differences between sql override and lookup override?
Explain the difference between a data warehouse and a data mart?
Performance tuning( what you did in performance tuning)
Enlist the differences between database and data warehouse.