We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
IBM,
2 6042There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
IBM,
4 7522
What are normalization, first normal form, second normal form and third normal form?
What is the purpose of joins in teradata and what are the available join types?
What are the various etl tools in the market?
What is the syntax for case when statement?
What are the steps to create a data model?
What are the different table types that are supported by teradata?
Explain and compare pros and cons of start schemas?
What are the advantages of teradata?
What are the 5 phases in a multiload utility?
When tpump is used instead of multiload?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are aggregate tables? How do you design them using teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is a dimension table?