loading the data into Teradata View using Enterprise Stage

siva4joy · Post by **siva4joy** » 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.

richdhan · Post by **richdhan** » Tue Nov 13, 2007 12:38 pm

Hi Siva,

Create a Teradata table. Create a view based on the table and load the table instead.

Use the Teradata API stage. There were some issues with Teradata Enterprise stage at our site.

HTH
--Rich

ray.wurlod · Post by **ray.wurlod** » Tue Nov 13, 2007 4:39 pm

Loading to VIEWS is unsupported.

Seems pretty clear to me!

kduke · Post by **kduke** » Tue Nov 13, 2007 8:15 pm

Ray is correct. If you load into a view the error shows you that the indexes are not viewable. Certain indexes are required for specific Teradata APIs.

siva4joy · Post by **siva4joy** » Fri Nov 16, 2007 9:13 am

hi
actually the view had been created on the table only which had unique primary index .
but our requirement is we have to load in to the views not in to the tables.
can anybody tell me what is the difference between Teradata Api Stage and Teradata Enterprise Stage.
can we load the data in to the views if we can use Teradata Api Stage.
is there any performance issues will come?

ray.wurlod · Post by **ray.wurlod** » Fri Nov 16, 2007 4:21 pm

Which part of " Loading to VIEWS is unsupported." is unclear? The requirement can not be met.

As to whether one of the other stages can load a view, why not try it? Let us know. Not everyone out here has Teradata.