Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Understanding the Transformations

Understanding the Transformations

The following table describes the function of each transformation in the Type 1 Dimension mapping:
Transformation Name
Transformation Type
Description
SQ_
SourceName
Source Qualifier or Application Source Qualifier
Selects all rows from the source you choose in the Mapping Wizard.
LKP_GetData
Lookup
Caches the existing target table.
Compares key columns in the source against corresponding key columns in the target. When matching keys exist, LKP_GetData returns additional column data from the target for comparison.
Passes all rows to EXP_DetectChanges.
EXP_DetectChanges
Expression
Uses the following expression to flag source rows that
do not
have matching keys in the target. The expression returns TRUE if a matching key does not exist in the target, indicating the row is new:
IIF(ISNULL(PM_PRIMARYKEY),TRUE,FALSE)
Populates the NewFlag port with the results.
Uses the following expression to flag source rows that
have
a matching key in the target and contain changes in the specified columns. The expression returns TRUE only if a matching key exists in the target (indicating the row is not new) and if it detects a difference between source and target columns:
IIF(ISNULL(PM_PRIMARYKEY) AND (SourceColumnName<>PM_PREV_TargetColumnName) AND (other comparisons) TRUE,FALSE)
Populates the ChangedFlag port with the results.
Passes all rows to FIL_InsertNewRecord and FIL_UpdateChangedRecord.


Updated June 25, 2018