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 many sessions of MAX is PE capable of handling at a particular time?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is meant by a Highest Cost Plan?
What are the different methods ot loading a dimension table? A fact table etc?
Explain Teradata performance tuning and optimization?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is a clique?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
How do you do backup and recovery in teradata?
What are the uses of bynets in multi-node systems?
What are the different table types that are supported by teradata?
What is the use of having index on table?
What is meant by a Virtual Disk?
Can we collect statistics on table level?