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?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Teradata Interview Questions

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

0 Answers  


Increasing no of amps will increase performance. Is this true?

5 Answers   Infosys,


How to view every column and the columns contained in indexes in teradata?

0 Answers  


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

2 Answers   IBM,


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

4 Answers   Cap Gemini,


Give some points about Teradata Viewpoint ?

3 Answers   Teradata,


A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 Answers  


What's the syntax of sub string?

1 Answers  


What is meant by a Virtual Disk?

0 Answers  


What is real time and near real time data warehousing?

0 Answers  


What type of indexing mechanism do we need to use for a typical data warehouse?

0 Answers  


Can you load multiple data files for same target table using fastload?

1 Answers  


Categories