Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Increasing no of amps will increase performance. Is this true?
How to view every column and the columns contained in indexes in teradata?
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
Give some points about Teradata Viewpoint ?
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
What's the syntax of sub string?
What is meant by a Virtual Disk?
What is real time and near real time data warehousing?
What type of indexing mechanism do we need to use for a typical data warehouse?
Can you load multiple data files for same target table using fastload?