What is collect statistics?
No Answer is Posted For this Question
Be the First to Post Answer
Describe primary index in teradata?
When tpump is used instead of multiload?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Difference between multiload and tpump?
What is database exceptions in teradata?
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 is the difference between union and union all in teradata?
Explain the meaning of Amp?
Discuss the advantages of using partitioned primary index in a query?
What happens when a node suffers a downfall?
I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata