Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(3 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Calculate the estimated cache sizes for a Lookup transformation in PowerCenter
Solution

To calculate the estimated required disk space for Lookup transformation do the following:

  1. In the Workflow Manager open the session properties.

  2. On the mapping tab, select the Lookup transformation.

  3. Select Lookup Data Cache Size.

  4. Click the Calculate option.

  5. Enter a value for the Number of Rows with Unique Lookup Keys .

  6. Select the Data Movement Mode (ASCII or Unicode).

  7. Click Calculate >> to determine the required disk space for the data cache.

  8. Click OK.

  9. Select Lookup Index Cache Size.

  10. Click the Calculate option.

  11. Enter a value for the Number of Rows with Unique Lookup Keys .

  12. Select the Data Movement Mode (ASCII or Unicode).

  13. Click Calculate >> to determine the required disk space for the index cache.

More Information
Reference
Applies To
Product: PowerCenter
Problem Type:
User Type: Developer
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:12/8/2010 11:55 AMID:22530
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)