Interested to Buy Any Domain ? << Click Here >> for more details...
How to Skip or Get first and Last Record from Flat File
through MultiLoad and TPUMP Utility?
- 4 Answers
- 26905 Views
- Comsys, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / milind mane
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 ? | 11 Yes | 4 No |
Answer / yuvaevergreen
Adding to the above, if from n"start record" and for n "stop
record" are not mentioned, mload considers records from
start till the end of the file.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / tdguy
Two options, FROM 'n' THRU 'm' can be used or FOR 'n' can
be used.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kvsnr
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 | 10 No |
What are the various indexes in teradata? How to use them? Why are they preferred?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Why Multiload does not supports USI and supports NUSI?
Explain teradata architecture in detail with a diagram.
Name the five phases that come under MultiLoad Utility.
Explain teradata utilities. What is multiload, fast load, tpump?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
What is meant by a Least Cost Plan?
What is difference between user and database in teradata?
What is the difference between union and union all in teradata?
Teradata 
