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 / kishore
as the fastload supports restartability....if the script fails after loading 120 records....restart the script by rectifying errors...later it starts from last failed point in the log table....starts record loading from 121....(FAST LOAD DOES NOT SUPPORT DUPLICATE RECORDS because of the restartability concept)
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is the difference between union and union all in teradata?
List out some of the primary characteristics of teradata.
Steps to create a data model?
What is node? How many nodes and amps used in your previous project?
What are the commands to make a new table, change a table and remove a table in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is teradata? Also, list out some of the primary characteristics of teradata.
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
how many modules are there in telecome domain?how to explain the architecture?
In Teradata, how do we Generate Sequence?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What happens in a conflict? How do you handle that?
How will you solve the problem that occurs during update?
Highlight the differences between Primary Key and Primary Index.
Explain amp in teradata?