loading the data into Teradata View using Enterprise Stage
Posted: Tue Nov 13, 2007 12:25 pm
Hi all,
I am loading the data in to a teradata view fron the dataset using Teradata Enterprise Stage, but i am getting the following error.
tdtPdwDA_PDW_LN1K: Error when checking operator: Table 'CXA486_CIDLIVE.DA_PDW_LN1K' does not exist! Cannot use truncate mode. Ensure that target is a TABLE object and not a VIEW object. Loading to VIEWS is unsupported.
Error when checking operator: Cannot prepare target table.
because we don't have a options called as view in this stage.
so i am giving view's name in the table options.
my question is can we load the data in to a view?
Thanks for your help.
I am loading the data in to a teradata view fron the dataset using Teradata Enterprise Stage, but i am getting the following error.
tdtPdwDA_PDW_LN1K: Error when checking operator: Table 'CXA486_CIDLIVE.DA_PDW_LN1K' does not exist! Cannot use truncate mode. Ensure that target is a TABLE object and not a VIEW object. Loading to VIEWS is unsupported.
Error when checking operator: Cannot prepare target table.
because we don't have a options called as view in this stage.
so i am giving view's name in the table options.
my question is can we load the data in to a view?
Thanks for your help.