Hi All,
Iam having one requirement to load data into Materlized Query table(DB2) same as Materlized view( Oracle. )
My source is Dataset.And i'm using Datastage 7.5 version.
Please let me know whether it is possible to load the data into Materlized query table through datastage parallel job.
Thanks,
chandra
Materlized query table(DB2)
Moderators: chulett, rschirm, roy
Materlized query table(DB2)
Chandra Mouli
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
The answer is yes. For DataStage it would just be another table, your DBA needs to set it up as a user manintained MQT.
http://publib.boulder.ibm.com/infocente ... 009318.htm
http://publib.boulder.ibm.com/infocente ... 009318.htm
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com