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

what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

TCS,

1 2781

what is combinability and non combinability?

2 15914

Why we need datasets ratherthan sequential files?

5 31904

what is the diff between sequential file and fileset stages?

3 26818

what is sparse lookup?

IBM,

7 31688

wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.

1 5346

how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 8722

how do you validate sas program?

Accenture,

6 14032

define table lookup and how may ways it can be done...explian

3 6580

explain project, package ,model , modelers.........and differences b/w them?

HCL,

4 12023

Once reports are delivered to client, how will they inform back? If they are experiencing any problem in the reports.

2 5754

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

Accenture,

2 10200

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

2026

After we make a folder shared can it be reversed?Why?

Accenture,

2 12327

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4399

Un-Answered Questions { Data Warehouse }

Explain the difference between oltp and olap?

1132

what are the production issues in datastage?

10433

Explain is there any other repository domains rather than universe, security, document?

1107

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1906

how to create reports on screech?

2570

What are the stages that are required in data warehousing?

973

Explain etl mapping sheets?

1089

What do you mean by consolidations?

1056

Explain clustering algorithm?

2284

Explain BYNET.

1016

How do you connect the desktop application to metadata server? : sas-grid-administration

1115

What are templates in which way it is help full?

1006

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1026

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2635

Are you involved in writing the inferential analysis plan? Tables specfications?

2237

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