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?
Answer Posted / mahesh raja
Fastload will load the records in to target table
after .END LOADING statement only, so the extra 20 records
wont populate in target table so restart will work from 101
record onwords.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the steps to create a data model?
Did you write stored procedures in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
What are the available primary index types?
Explain teradata utilities?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What interface is used to connect to windows based applications?
In general, how do you optimze any sql in teradata?
Define views in teradata with syntax.
What is meant by a dispatcher?
What is basic teradata query language?
What is smp and mpp platforms?
How to load specific no.of records using bteq, or fastload,or multiload
Write a program to show the parser component used in teradata?