SCD Purpose Codes
Posted: Wed Apr 07, 2010 4:30 pm
As per the IBM documentation:
Updating the dimension table
Purpose codes are part of the column metadata that the SCD stage propagates to the dimension update link. You can send this column metadata to a database stage in the same job, or you can save the metadata on the Columns tab and load it into a database stage in a different job. When the database stage uses the auto-generated SQL option to perform inserts and updates, it uses the purpose codes to generate the correct SQL statements.
It says the it writes the purpose codes on the output link so that DB stage can figure out what sql to generate?
I dont see these purpose codes any where on the output link? Any thoughts where its storing them on the output link?
Updating the dimension table
Purpose codes are part of the column metadata that the SCD stage propagates to the dimension update link. You can send this column metadata to a database stage in the same job, or you can save the metadata on the Columns tab and load it into a database stage in a different job. When the database stage uses the auto-generated SQL option to perform inserts and updates, it uses the purpose codes to generate the correct SQL statements.
It says the it writes the purpose codes on the output link so that DB stage can figure out what sql to generate?
I dont see these purpose codes any where on the output link? Any thoughts where its storing them on the output link?