Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What is the use of fallback?

1007

What exactly do you know about catching in teradata?

1049

What is smp and mpp platforms?

984

What is teradata? What are some primary characteristics of teradata?

983

What are the joins in teradata?

1029

What are the updated features of teradata?

1055

Explain the advantages of partitioned primary index in a query?

1038

What is database exceptions in teradata?

964

What is the difference between teradata and basic rdbms?

1036

What are the different table types supported by teradata?

981

What are the joins in teradata and how many types of joins are there in teradata?

1015

Explain the parallel data extension in teradata?

1110

What is called partitioned primary index (ppi)?

1023

Explain some differences between mpp and smp?

1117

What is upsert statement in teradata?

1148

Un-Answered Questions { Data Warehouse }

Can a dimension table contain numeric values?

1073

What does reusable transformation mean?

1148

What are templates in which way it is help full?

1007

What is a passive transformation?

1118

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1061

how get the grand total in master-detail report?

2244

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2148

What are the different types of data warehousing?

972

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2946

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1147

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2190

hi,can you please share with me about,what is reportlimit,report order and how can create and use

5279

How do you import and export the datastage jobs?

1173

Name the different types of Lookups in Datastage?

1274

what is change analysis in sas di ? : Sas-di

1067

For More Un-Answered { Data Warehouse } Questions Click Here