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 3088

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 10443

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 9844

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

1 2882

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 5612

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 8707

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

TCS,

9 61292

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 7586

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,

2040

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 the differences between sql override and update override?

1100

Explain is there any comparison available for cognos reportnet vs crystal reports?

965

What are non-additive facts in detail?

995

Explain in detail scd type 2 through mapping.

1041

what is session partitioning?

1879

For what purpose would you use the RETAIN statement?

1524

What are the advantages of using sas?

1147

Mention what are the data types does SAS contain?

1153

Explain what is redshift?

What is tracing level? How many types of transformations supported by sorted input?

973

How does the aggregator transformation handle null values?

1149

What is the precedence of stage variables,derivations, and constraints?

1086

Runtime behavior of Normalize and Reformat

2710

How might you approve all mappings in the archive all the while?

1018

Explain datawarehousing?

1044

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