Teradata Connector Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 64
- Joined: Fri Jan 25, 2008 4:41 am
Teradata Connector Stage
I am trying to insert/update data through a view but the problem is that when we try do multiload insert(Append mode), Datastage create a temp table with the following query Create Table TempTable AS ViewName WITH No Data; so the datastage fails that ViewName is not a table while in Enterprise stage it use the statement Create Table TempTable AS Select * From ViewName; to create this temp table. Is there any trick to do some work around with Teradata connector stage so that it can insert into View when using Multiload mode in Teradata Connector.
The other option if you prefer to use the Load operator (FastLoad) is to load a temporary staging table, and then specify an INSERT...SELECT statement in the After SQL property to copy the data from the staging table to the target view. You can create the staging table using the Table action property.
-
- Participant
- Posts: 64
- Joined: Fri Jan 25, 2008 4:41 am