Interview Questions   Tutorials   Discussions   Programs   

Teradata - What is FILLER command in Teradata?

asked mar September 20, 2014 06:38 AM  

What is FILLER command in Teradata?


1 Answers

answered By vishnoiprem   0  
While running Fastload or Multiload if you don’t want to load a particular field from the datafile to the target table then use the FILLER command to achieve this.

Syntax for FILLER command would be as following:

.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
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!