Referring to a Lookup Transformation: Which of the Following Statements

question 56

Multiple Choice

Referring to a lookup transformation: Which of the following statements are true and correct?

• A) The caching of a flat file is optional if the data in the flat file is sorted
• B) The lookup index cache file contains a searchable index of the records based on the lookup condition
• C) When lookup caching is unchecked, PowerCenter will read from a locally stored cache file
• D) The data cache contains all of the fields in the lookup transformation

---

Definitions:

Observed Values

The actual values that are measured or collected during an experiment or survey.

Predicted Values

In statistics, these are the estimated outcomes based on a regression model or other predictive model.

Coefficient of Determination

A statistical measure represented by R² that assesses the extent of variance in a dependent variable that is predictable from the independent variable(s).

Regression Model

A statistical framework that predicts the connection between a dependent variable and one or several independent variables.