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 3187

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 10655

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 9990

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

1 2963

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 5719

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 8862

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

TCS,

9 61687

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

2328

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

HCL,

4 9665

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

Reddy Labs,

3 7742

what is the primary variable in your study?

Accenture,

3 15817

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

Accenture, Quintiles,

2260

Did you used proc test? when?

Accenture, Quintiles,

2099

Did you used proc lifetest? when?

Accenture, Parexel, Quintiles,

2 10659

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

Accenture, Quintiles,

3189

Un-Answered Questions { Data Warehouse }

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

2007

What is the command manager?

1053

Can we create a node as a gateway node and the same node can be assigned to a grid?

1132

What is the dense rank?

1341

How to create a repository in abinitio for stand-alone system(local nt)?

1185

-----------With out using DrillThrough how to do Reports?

2104

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1863

Can a dimension table contain numeric values?

1122

What is the difference between a scan component and a rollup component?

1246

what is the use of server?

2266

Describe expression transformation?

1175

What is the roundrobin collector?

1164

Explain absolute filter?

1050

Explain difference between data ware house & data mart?

1038

What is the use of target designer?

1123

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