Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

CREATE OR REPLACE VIEW DM2_LOAD_1_ERRORS AS

 SELECT SOURCE_ROW_NUM FROM (SELECT DISTINCT SOURCE_ROW_NUM FROM DM2_LOAD_ERROR_VIEW WHERE BATCH_ID = 1);

Step 5 – create Dimension Table in a database, optional step

This step is run if parameters Table Name and Key Fields are not null in a profile.

...