What r the joiner caches?

When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows.
After building the caches, the Joiner transformation reads records from the detail source and perform joins.

  • Interview Candidate
  • 5
  • 4203

Showing Answers 1 - 5 of 5 Answers

Praveen Vasudev

  • Sep 12th, 2005
 

From a performance perspective.always makes the smaller of the two joining tables to be the master.

  Was this answer useful?  Yes

sithusithu

  • Jan 19th, 2006
 

Specifies the directory used to cache master records and the index to these records. By default, the cached files are created in a directory specified by the server variable $PMCacheDir. If you override the directory, make sure the directory exists and contains enough disk space for the cache files. The directory can be a mapped or mounted drive.
 
Cheers,
Sithu

  Was this answer useful?  Yes

bneha15

  • Apr 23rd, 2007
 

For version 7.x and above :

When the PowerCenter Server processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The PowerCenter Server then performs the join based on the detail source data and the cache data. To improve performance for an unsorted Joiner transformation, use the source with fewer rows as the master source. To improve performance for a sorted Joiner transformation, use the source with fewer duplicate key values as the master.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions