What is FILLER command in Teradata?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 31 Yes | 0 No |
Answer / 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 |
Answer / yuvaevergreen
Adding to the above, filler command just accounts for the
input record layout and is not sent to the teradata.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / tdguy
Filler command is just used for input data format, but the
data is not sent to teradata. Used with Layout command in
Mload.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / subbareddy kake
For Surya...
Filler is not related to any phase.
We can use filler for skipping the few columns from the
source file to target table.we will write thefiller in sql
layout in the Mload script
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sivareddy
filler is nothing but avoid that column while exceution time
syn:.filler empno char(2).
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / m.s
Can filler be used in Fastload and if it can be used to
filter tows coming from data file ?
That is, can I do the below fucntionality of multiload in
fastload ?
ex:
.apply dml_insert where filler = 'a'
Is This Answer Correct ? | 1 Yes | 2 No |
What is the maximum number of dml can be coded in a multiload script?
Fast Load Script is failed and error tables are available then how do you restart?
Highlight all the modes that are present under Confidence Level.
Can any one plz provide the teradata interview questions?
Explain fallback in teradata?
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
What is spool space?
What are the uses of bynets in multi-node systems?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
What is the purpose of using case expression in teradata?
What interface is used to connect to windows based applications?
How can we check the version of Teradata that we are using currently?