How many types of joins are there in teradata?

724

What is dimensional modeling?

819

Highlight a few of the advantages that ETL tools have over Teradata.

863

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3133

What do you mean by caching in teradata?

821

What are the different functions included in the server software?

801

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

820

Explain and compare pros and cons of snow flake schemas?

806

What are the different table types that are supported by teradata?

754

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

947

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

836

What is upsert statement in teradata?

821

How to select first n records in teradata?

811

While creating table my dba has fallback or no fallback in his ddl. What is that?

891

Highlight the advantages of PPI(Partition Primary Index).

785