Interview Questions   Tutorials   Discussions   Programs   

Teradata - What is FILLER command in Teradata?




1742
views
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
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


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!

Alert