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 are the steps to create a data model?
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
Can we collect statistics on multiple columns?
Explain the teradata primary index mechanics in detail with a diagram.
Why are oltp database designs not generally a good idea for a data warehouse?
Define views in teradata with syntax.
What is a clique?
Explain teradata vs. Redshift?
In the Primary Index, what is the score of AMPs that are actively involved?
Mention a few of the ETL tools that come under Teradata.
What do you mean by teradata intelliflex?
How many types of joins are there in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is logical data model?
What is a three-tier data warehouse?