Wednesday, November 14, 2012

What is FILLER command in Teradata?


while using the mload of fastload if you don;t want to load
a particular filed in the datafile to the target then use
this filler command to achieve this.


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 */

1 comment:

  1. Actually, I am facing some difficulties to understand the meaning of the blog. If you have any short video film related to your blog, then I would request you to share here. It would be great help.ฉีด โบท็อก

    ReplyDelete

Thank you :
- kareem