What is the use of having index on table?
Why MLOAD needs Work Tables?
Why managing the data is important?
what is identity columns in teradata
why should we go Teradata over Oracle,what is the main differences?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
What's the difference between timestamp (0) and timestamp (6)?
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
Explain PDE.
What are the different softwares used with their functions in teradata?
In general, how do you optimze any sql in teradata?
what is single value and Multivalue ?