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 .abinitiorc and What it contain?

CSC,

3 38762

What are the components new in 2.14 compared to 1.8 and State the usage of the components?

2280

Describe the effect of the "checkpoint" t-sql statement?

1 5496

Describe what the SQL Server tempdb and tlog files are used for?

2392

Why might the optimizer use a table scan when an index is available?

2359

How might you quantitatively measure an improvement made to a query?

2 9601

What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox?

JPMorgan Chase, Syntel,

5 34423

what does layout means in terms of Ab Initio?

3 26964

How do we handle if DML changing dynamicaly?

GE, HP, IBM, Mannar Company,

5 33309

How can we test the abintio manually and automation?

JP Group,

1 7137

How will you use EME for view or publish metadata reports using EME?

1 5944

How to Improve Performance of graphs in Ab initio?

TCS, Wells Fargo,

2 29885

what is the difference between .dbc and .cfg file?

Cap Gemini,

3 20925

How to get DML using Utilities in UNIX?

1 16818

what is skew and skew measurement?

TCS,

2 19795

Un-Answered Questions { Data Warehouse }

On which Dimension Table you implemented SCD Type in your Project

2117

Define views in teradata with syntax.

1131

Explain the data types present in bo and what happens if we implement view in the designer and report?

1076

In BTEQ, how are the session-mode parameters being set?

1192

Your account is locked and your administrator has forgotten the password. What would you do?

1108

Explain the importance of data warehouse?

1067

How conflicts occur and what are the ways to resolve them?

1011

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2134

How we can monitor the performance of Redshift data warehouse cluster.

What dedup-component and replicate component does?

1327

explain about various caches available in data integrator? : Sas-di

1120

What is a relationship?

1041

What is the syntax for case when statement?

1222

A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

2069

what is program data vector? : Sas-administrator

1126

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