ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Teradata
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
What is FILLER command in Teradata?
 Question Submitted By :: Srinu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is FILLER command in Teradata?
Answer
# 1
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 ?    7 Yes 0 No
Girish Jena
 
  Re: What is FILLER command in Teradata?
Answer
# 2
ok Girish,
can u send the SYNTAX for Filler command
 
Is This Answer Correct ?    5 Yes 2 No
Srinu
 
 
 
  Re: What is FILLER command in Teradata?
Answer
# 3
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 ?    3 Yes 0 No
Kvsnr
 

 
 
 
Other Teradata Interview Questions
 
  Question Asked @ Answers
 
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen? IBM2
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility? IBM2
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.  2
Does SDLC changes when you use Teradata instead of Oracle?  1
What is Join Index in TD and How it works? TCS1
What is the diffrence between Multiload & Fastload interms of Performance? Intel3
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.  4
can I use “drop” statement in the utility “fload”? Accenture1
What is use of compress in terdata?Explain?  3
Can any one plz provide the teradata interview questions?  2
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?  1
Increasing no of amps will increase performance. Is this true?  1
What are two examples of an OLTP environment?  1
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ? IBM3
Explain about Skew Factor?  4
What is FILLER command in Teradata? CTS3
Can we load a Multi set table using MLOAD?  1
Why AMP & PE are called Vprocs?  2
what is the difference between bpo and call centre? American-Solutions1
How a Referential integrity is handled in Teradata?  2
 
For more Teradata Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com