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 2820

what is combinability and non combinability?

2 16043

Why we need datasets ratherthan sequential files?

5 32097

what is the diff between sequential file and fileset stages?

3 26928

what is sparse lookup?

IBM,

7 31871

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

1 5428

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 8849

how do you validate sas program?

Accenture,

6 14219

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

3 6673

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

HCL,

4 12134

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

2 5853

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

Accenture,

2 10294

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?

2072

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

Accenture,

2 12412

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)?

4447

Un-Answered Questions { Data Warehouse }

Explain swot analysis?

1236

What is primary and backup node?

1175

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2606

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

985

In development project what is the process to follow for an etl developer from day1

1760

Can you define bitmap index?

1135

Explain two-tier connection?

999

which date function advances a date, time or datetime value by a given interval? : Sas programming

1097

You can ask about different vector functions. How to use in abinitio graph?

5594

explain the function of substr in sas? : Sas-administrator

1070

Explain datawarehousing?

1122

How many data types are there in SAS?

1139

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3929

What is the meaning of decode in informatica?

1167

What are the difference between sas functions and procedures?

1204

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