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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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
How to Skip or Get first and Last Record from Flat File 
through MultiLoad and TPUMP Utility?
 Question Submitted By :: Hardeep
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Answer
# 1
MultiLoad is going to need to know the structure the INPUT 
flat file. Use the .LAYOUT command to name the layout.
It is used to designate the starting location for this data 
based on the previous fields length. If you are listing 
fields in order and need to skip a few bytes in the record, 
you can either use the .FILLER (like above) to position to 
the cursor to the next field, or the "*" on the Dept_No 
field could have been replaced with the number 132 ( CHAR
(11)+CHAR(20)+CHAR(100)+1 ). Then, the .FILLER is not needed
 
Is This Answer Correct ?    2 Yes 2 No
Kvsnr
 
  Re: How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Answer
# 2
In .IMPORT command in MLoad  we have a option to give 
record no. from which processing should begin. ie. ‘FROM m’
‘m’ is a logical record number, as an integer, of the 
record in the identified data source where processing is
to begin. You can mention ’m’ as 2 and processing will 
start from second record.

THRU k and FOR n are two options in the same MLoad command, 
functions same towards the end of the processing.
 
Is This Answer Correct ?    0 Yes 1 No
Milind Mane
 
 
 

 
 
 
Other Teradata Interview Questions
 
  Question Asked @ Answers
 
Can we load a Multi set table using MLOAD?  1
Increasing no of amps will increase performance. Is this true?  1
Why AMP & PE are called Vprocs?  2
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?  2
What is a common data source for the central enterprise data warehouse?  1
what is the difference between start schma and Fsldm? Intel3
Can any one plz provide the teradata interview questions?  2
What is use of compress in terdata?Explain?  3
What is Join Index in TD and How it works? TCS1
How to find No. of Records present in Each AMP or a Node for a given Table through SQL? IBM1
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
Explain about Skew Factor?  4
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?  2
What is the process to restart the multiload if it fails?  3
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?  1
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
can I use “drop” statement in the utility “fload”? Accenture1
what is the difference between bpo and call centre? American-Solutions1
I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com IBM4
 
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