User maintained MQTs

miwinter · Post by **miwinter** » Mon Jan 17, 2011 6:36 am

We have one of these in our environment and have found that when trying to import the table definition it cannot be viewed, only tables and views can be found when using the plug in metadata definitions (DB2). The same appears to hold true in v7x and v8.1. As such, it means the user maintained MQTs cannot be loaded through Datastage... to benefit from parallelism. Does anyone have any workaround to this or otherwise please?

chulett · Post by **chulett** » Mon Jan 17, 2011 9:16 am

You're not required to import metadata, it can be created by hand. You could also create a temp table that looks like your MQT and then import from that.