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 3092

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 10454

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 9852

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

1 2894

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 5625

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 8721

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

TCS,

9 61315

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

2249

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

HCL,

4 9470

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

Reddy Labs,

3 7598

what is the primary variable in your study?

Accenture,

3 15686

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

Accenture, Quintiles,

2202

Did you used proc test? when?

Accenture, Quintiles,

2048

Did you used proc lifetest? when?

Accenture, Parexel, Quintiles,

2 10529

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

Accenture, Quintiles,

3115

Un-Answered Questions { Data Warehouse }

What is the primary index in teradata?

1208

Could any one explain me how to create cascading prompts?

1072

what kind of system requirement is needed to run tm1 for a small installation?

How can we remove the duplicates from flat file source?

1046

Differentiate between validated and Compiled in the Datastage?

1288

What we need to discuss with designer before starting the universe designing.

2253

What are all the types of hierarchies?

1139

What are the various kinds of containers available in datastage?

1048

What is a transaction control transformation?

1214

How do you use the do loop if you don’t know how many times you should execute the do loop?

1267

hi real timers . iam waiting for ur reply regarding ETL TESTING

2274

How to update source definition?

1100

Explain data flow graph with an example?

1137

Is Redshift a row based storage or columnar based?

Explain the difference between detect alias and detect context?

1110

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