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 3089

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 10449

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 9850

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

1 2884

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 5617

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 8710

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

TCS,

9 61294

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 9454

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

Reddy Labs,

3 7587

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,

2041

Did you used proc lifetest? when?

Accenture, Parexel, Quintiles,

2 10519

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

Accenture, Quintiles,

3110

Un-Answered Questions { Data Warehouse }

What is the difference between static and dynamic conditions?

1085

4 yrs etl devloper roles and responsibilities?any body give solutions

2168

How to implement security measures using repository manager?

1178

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058

What is the command manager?

1002

What is the purpose of upsert command?

1177

Mention what is SAS data set?

1132

How to create a permanent sas data set?

1239

why is a stop statement needed for the point=option on a set statement? : Sas programming

1085

define cognos connection?

What is the difference between absolute filtering and standard filtering?

1052

how can you create zero observation dataset? : Sas programming

1148

explain about balanced dimension,

982

How do you verify a complicated sql?

1067

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

962

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