What is database exceptions in teradata?

712

What is a three-tier data warehouse?

802

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1528

What is the command in bteq to check for session settings ?

858

How do you set the session mode parameters in bteq?

792

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

830

Explain parsing engine in teradata?

800

Explain PDE.

826

Explain the meaning of Amp?

770

How would you load a very large file in teradata in general?

784

What is the purpose of upsert command?

803

What are the functions of a Parser?

788

Explain the new features of teradata?

786

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?

940

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1810