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

h0w many versions have been developed of onformatica so far?

1 3086

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

Patni,

5 10442

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

Patni, Tech Mahindra,

2 9842

What are Dashboard reports?And significance of these in analysis?

1 2880

How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.

2 5610

How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.

TCS,

4 8706

how lookup is acting as both active and passive ? how is it possitble?

TCS,

9 61287

can any one pls send me the project flow at the time of interview

2245

can any one tell me how to create a new universe from scrach with step by step process.

HCL,

4 9452

How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?

Reddy Labs,

3 7584

what is the primary variable in your study?

Accenture,

3 15670

what are all the reports you generated in your recent project?

Accenture, Quintiles,

2199

Did you used proc test? when?

Accenture, Quintiles,

2039

Did you used proc lifetest? when?

Accenture, Parexel, Quintiles,

2 10517

In proc transpose and data step with arrays which one you pick?

Accenture, Quintiles,

3110

Un-Answered Questions { Data Warehouse }

what are logical views used for?

1011

What is meant by metadata in context of a data warehouse and how it is important?

1203

How many ways to overcome a missing values???

2809

What are the steps to do to use alerts in bo?

1394

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2138

Tell e how how dealt with..

2253

Design a mapping to load a target table with the following values from the above source?

1346

what are the other factors of the database on which the loading performance depend?

1909

What is the difference between one to one merge and match merge? Give an example.

1067

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2799

What is smp and mpp platforms?

971

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

991

Where the applications and where ware house management system is used?

1014

How we drill up week to month?

1076

What is recovering sessions?

936

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