Thursday, March 6, 2008

ITM 6.1 and DB2 table names in TDW 2.1

In case anyone is interested. The table naming scheme is different between the OS componenet and the DB2 PAC in the TDW 2.1

Example - When the WPA creates the NT_Services table in the TDW, it is named "NT_Services" - complete with quotation marks.

When using the DB2 PAC and enabling warehouse data, the naming convention is much different on these tables - it still follows the Attribute Group convention but here is a sample.

KUDDB2APPLGROUP00 stores data from the Application Group 00. Note that the convention is all CAPS and does not include Quotes.

No comments: