Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to relege locks in fastload and multiload? example?

Answer Posted / yuvaevergreen

For mload,
release mload in apply can be used to forcefully remove the lock from the target table.
For fload,
Locks on target table will not be released until end loading statement completes. I hope fload should be run only with begin and end loading statements. Please add, if you find more....

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1039


How to select first n records in teradata?

1064


Explain the meaning of Amp?

1064


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1058


Steps to create a data model?

1085


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2116


What are the advantages of teradata?

966


What is the basic syntax for teradata select statement?

1005


Difference between star and snowflake schemas?

1092


What does Amp contain and what are all the operations that it performs?

965


How many tables can you join in v2r5?

1020


Why managing the data is important?

978


If RDBMS is halted what will you do ?

2123


What is meant by a Least Cost Plan?

1018


Explain the term 'tables' related to relational database management system?

1000