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

Hi All, If anyone of you had very Latest & Authentic BUSINESS OBJECTS - XI Certification Dumps for the below Codes, can you please forward it to me, its really very urgent to me SABE 201, SABE 301, SABE 401, SABE 501V3.0 Thanks Mohan

3 6176

what are the cubes developed in a sap bw project and what is the requirement for developing it?

Maersk,

2137

what are the reports developed in sap bw project and what is the requirement for developing it?

Maersk,

2229

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

Accenture,

2179

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

Accenture,

2685

in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?

Accenture,

2 10988

why varchar takes 2 extra bytes?

IBM,

4 15594

Which are SAS Windows Clients & SAS Java Clients

TCS,

3 10083

How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO

TCS,

2 11368

how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.

TCS,

1 6574

What is SAS Information Map Studio and its purpose ?

SAS, TCS,

2 16090

what are different type of sas servers ? On which server does the sas code execute ?

TCS,

4 14799

what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.

TCS,

1 10072

HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

TCS,

1 13147

what is SAS ACCESS AND SAS CONNECT ? Give an example and data statements used.

TCS,

1 6783

Un-Answered Questions { Data Warehouse }

What is difference between user and database in teradata?

1120

List out all forms of LOCKS that are available in Teradata.

1011

Mention the difference between ‘macros’ and ‘prompt’?

1199

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?

2230

What are the etl testing operations includes?

1158

explain about data integrator metadata reports? : Sas-di

1171

What are the data types that sas contain?

1254

How many universes can be created in a project?

1097

AWS Redshift is basically works on nodes and cluster and which of following option Redshift is based on?

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1076

tell me few points when u become TL

2615

Explain difference between data ware house & data mart?

1034

What are the different modes to run i-server?

1138

Explain about core dimension, balanced dimension, and dirty dimension?

1063

In development project what is the process to follow for an etl developer from day1

1760

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