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 are the different methods ot loading a dimension table? A fact table etc?

1 1097

What are default access rights in teradata?

1 1233

Explain teradata utilities?

1 1115

What is spool space?

1 1235

How do you create tables? Exact syntax, and create profiles, users in teradata?

1 1096

What tools would you use for that?

1 1180

In general, how do you optimze any sql in teradata?

1 1108

What are the various indexes in teradata? How to use them? Why are they preferred?

1 1125

How do you do backup and recovery in teradata?

1 1108

Explain the teradata primary index mechanics in detail with a diagram.

1 1070

Explain and compare pros and cons of start schemas?

1 1181

How to stop/start redshift cluster?

1 47

What are key differences between sql server and amazon redshift?

1 40

How do we execute sql file on redshift?

1 40

Explain the architecture of amazon redshift?

1 42

Un-Answered Questions { Data Warehouse }

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670

how many reports have u created ? explain a few.

2160

Hi friends, what are the new features in abinito3.0?

2860

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1176

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6075

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2766

What r the names of the reports that you prepared?

1029

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

3441

Explain in detail about scd type 1 through mapping.

1646

Write the unconnected lookup syntax?

1146

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

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