C2090-424 – InfoSphere DataStage v11.3

Select an option, then click Submit answer.

• ○

  Surrogate keys are used to join a dimension table to a fact table in a normalized schema database

• ○

  Each SCD stage processes multiple dimensions and performs lookups by using an equality matching

• ○

  Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.

• ○

  Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link
  
  

Select an option, then click Submit answer.

• ○

  All Rows

• ○

  One Row

• ○

  Zero Rows

• ○

  2000 Rows
  
  

Select an option, then click Submit answer.

• ○

  Multiple parameters and only one value file

• ○

  Only one parameter and only one value file

• ○

  Multiple parameters and multiple value files

• ○

  Only one parameter and multiple value files