Un-Answered Questions { Teradata }

What is a level of granularity of a fact table?

635


What is logical data model?

630


What are normalization, first normal form, second normal form and third normal form?

617


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

670


What is the purpose of indexes?

581


What type of indexing mechanism do we need to use for a typical data warehouse?

604


Can we collect statistics on multiple columns?

556


Can you connect multiload from ab initio?

634


Why does varchar occupy 2 extra bytes?

597


Why are oltp database designs not generally a good idea for a data warehouse?

591


What's the difference between timestamp (0) and timestamp (6)?

622


What do high confidence, low confidence and no confidence mean in explain plan?

579


How many tables can you join in v2r5?

613


What are the things to be considered while creating secondary index?

622


What is a three-tier data warehouse?

622