Do joiner transformation use cache? If so describe?
Answers were Sorted based on User's Feedback
Answer / mike
Yes joiner transformation has cahches. It joins the data
based on master detail joining condition. It first reads
the master source and stores it in the joiner cache and it
reads the detail source and joins with the data in the
joiner cache based on the master detail joining condition.
correct me if i was wrong
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / krish
Caching Master Rows
When the Integration Service processes a Joiner
transformation, it reads rows from both sources concurrently
and builds the index and data cache based on the master
rows. The Integration Service then performs the join based
on the detail source data and the cache data.
ur right buddy
| Is This Answer Correct ? | 2 Yes | 0 No |
What is intricate mapping?
Define sessions in informatica etl?
Implementation methodology
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
Clarify the utilization of aggregator cache record?
Are there any types of Dynamic Caches in informatica
Difference between task flow and linear task flow
What is the sql query overwrite in source qualifier in informatica
What is data transformation manager process?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me