What is FILLER command in Teradata?

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


Please Help Members By Posting Answers For Below Questions

Different phases of multiload?

598


Explain the term 'columns' related to relational database management system?

552


Highlight a few of the advantages that ETL tools have over Teradata.

617


Why is the case expression used in teradata?

597


What are teradata utilities?

592






Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1969


In general, how do you optimze any sql in teradata?

555


Describe primary index in teradata?

591


What happens in a conflict? How do you handle that?

632


Explain the teradata primary index mechanics in detail with a diagram.

573


Difference between star and snowflake schemas?

609


Explain teradata utilities?

576


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 ?

1904


What is the purpose of upsert command?

597


What is meant by a node?

623