Can we use TPT load/Update operator and insert into Views instead of Tabless directly? In the Reference document, for the attributes of Load/Update Operator, only VARCHAR TargetTable is mentioned in the syntax. But in user guide
Teradata PT can load data into, and export data from, any accessible database object in the
Teradata Database or other data store using Teradata PT operators or access modules.
Please let me know
The Load and Update operators do not support loading into views. That is a restriction of the FastLoad and MultiLoad protocols (from the DBS).
You can use the TPT Stream operator (similar to using TPump) but that loading will not be as fast as the other protocols.
Normally I would never question your word, but Multiload manual (V13 I am looking at) specifically says you can use Multiload into updatable views (generally single table views). See the final paragraphs of the BEGIN MLOAD command. I have used this in the past in both Mload and - I think Fload.
Is TPT different for views?
Then I stand corrected. If the MultiLoad protocol allows views (I have always been under the impression that those 2 utilities canno load views, but if the documentation says otherwise, then so be it), then you will be able to do the same with the TPT Update operator.
The TPT operators use the exact same protocols as their older utility counterparts. So the DBS restrictions and rules are the same.
As for the "TargetTable" keyword, do not get hung up on the name of the attribute. It defines the DBS object to get loaded. It does no make sense for us to have an attribute called ViewName. Just use TargetTable. Afterall, the data is going into a table, isn't it?
Yes, you can use TPT to export data referring to Views.
Please verify necessary cross-db grants are in place and userid used in TPT has SELECT access on View DB.
Thanks Velu! Is there any default option in TPT to get the "Hearders" along with export?
Example: Varchar header='yes'
Can you please help on this!