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
How can we check the version of Teradata that we are using currently?
What do you mean by teradata sql assistant?
Explain the term 'row' related to relational database management system?
What is multi insert?
What are the scenarios in which full table scans occurs?
What are the various indexes in teradata?
any one answer me how they can analyzing the project using data ware housing?
Explain the term 'foreign key' related to relational database management system?
Explain some differences between mpp and smp?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are teradata utilities?
What are some commonly used bteq scripts?
How many codd's rules are satisfied by teradata database?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are the functions of a Parser?