Interested to Buy Any Domain ? << Click Here >> for more details...
What is FILLER command in Teradata?
- 9 Answers
- 32307 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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 |
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is the opening step in basic teradata query script?
How to copy teradata scripts from ur remote desktop to server machine?
Why Multiload does not supports USI and supports NUSI?
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me
Why are oltp database designs not generally a good idea for a data warehouse?
Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
What do you mean by teradata sql assistant?
What is a dimension table?
Does SDLC changes when you use Teradata instead of Oracle?
Is multi insert ansi standard?
What happens when a node suffers a downfall?
Teradata 
