Answer Posted / kvsnr
For Srinu, i am posting my answer insted of girish for
SYNTAX for FILLER.
.LAYOUT FILE_IN; /* It is input file layout name */
.FIELD Emp_No * char(11); /* to load data in to Emp_no */
.FILLER Junk_chars * char(20); /* to skip the value for
the next 10 locations */
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
What are the different softwares used with their functions in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is meant by a Parsing Engine?
Define views in teradata with syntax.
What is a sparse index?
How is MLOAD Client System restarted after execution?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is the purpose of upsert command?
Discuss the advantages of using partitioned primary index in a query?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the things to be considered while creating secondary index?
Highlight the need for Performance Tuning.
What are the scenarios in which full table scans occurs?
What do you mean by teradata intellicloud?