This module will explain two different methods for transforming tables using the CrossTable and Generic prefixes.


Learning Objectives:

  • Identify features of crosstable and generic databases
  • Compare the Generic and CrossTable load prefixes
  • Implement CrossTable and Generic load examples
  • Implement a loop to merge output tables from a Generic load into a single table
  • Use Generic prefix to set Flags