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


Please Help Members By Posting Answers For Below Questions

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

652


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1783


What is the purpose of joins in teradata and what are the available join types?

555


Differentiate database data and data warehouse data?

596


What are aggregate tables? How do you design them using teradata?

645






What are the different functions included in the server software?

614


What is primary index and secondary index?

582


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1975


How to find duplicates in a table?

624


What is TPD?

914


Which is more efficient group by or distinct to find duplicates?

652


Explain Teradata performance tuning and optimization?

712


Highlight the points of differences between the database and user in Teradata.

603


How can we check the version of Teradata that we are using currently?

601


What do you mean by parsing?

641