Home
Contact
About
Navigation
Home
Interview Questions
Tutorials
Video Tutorials
Home
»
Teradata Interview Questions
»
What are SET tables and MULTISET tables in Teradata?
What are SET tables and MULTISET tables in Teradata?
in
Teradata Interview Questions
- on 00:27 -
No comments
Set table – Duplicates are not allowed while insertion.
Multiset table – Duplicates are allowed.
Tweet
Post a Comment
Newer Post
Older Post
Home
Categories
Teradata Interview Questions
Recent Comments
Popular Posts
What can be done to release fload locks?
1. Finish the fastload, which means leave your hands off of the error tables and restart fastload. When it finishes the table lock will be ...
What is identity column in TD?
In Teradata the identity column is the one, where the value gets inserted automatically (w/o any ETL intervention), by the described interva...
What is the difference between start schma and Fsldm?
FSLDM --> Financial Services Logical Data Model (Teradata FS-LDM 7.0) its developed by Teradata for the financial sectors (Speciafially f...
Teradata Scenario - interview question
A scenario like ,there is a BTEQ where it has delete statement followed by an insert and update.Suppose the delete statement has been execut...
What is the difference between Multiload and Fastload interms of Performance?
If you want to load, empty table then you use the fastload, so it will very useful than the multiload..because fastload performs the loading...
What is the process to restart the multiload if it fails?
MULTILOAD will creates 2 error tables, 1 work table When MULTILOAD fails We have to unlock the Main Table, here error tables and work tables...
What is error table? What is the use of log table?
The Error Table contains information concerning: - Data conversion errors Constraint violations and other error conditions: * Contains r...
how do you handle ET and UV errors in MLOAD (ET = Error table)?
In mload ET and UV tables, source sequence of the error records in the input file would be present. Use that number and delete/correct the...
Which is more efficient GROUP BY or DISTINCT to find duplicates?
With more duplicates GROUP BY is more efficient, if only a few duplicates exist DISTINCT is more efficient.
What is the need of collect statistics in teradata ? How does collect stats works in TD?
Collect stats is an important concept in teradata, collect stats gives parsing engine (PE) to come up with a plan with least cost for an req...
Live Traffic Stats
Post a Comment