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 2764

what is combinability and non combinability?

2 15904

Why we need datasets ratherthan sequential files?

5 31876

what is the diff between sequential file and fileset stages?

3 26796

what is sparse lookup?

IBM,

7 31662

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

1 5332

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 8702

how do you validate sas program?

Accenture,

6 14002

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

3 6554

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

HCL,

4 12006

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

2 5739

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

Accenture,

2 10182

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?

2009

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

Accenture,

2 12310

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

4391

Un-Answered Questions { Data Warehouse }

Describe crosslist option in tables statement?

1224

What are the different common services in datastage?

1287

What is the basic syntax for teradata select statement?

1049

-----------Diff b/w OLAP and RDBMS?

2046

Can you define metrics designer?

1058

How to add a number to a macro variable?

994

What are templates in which way it is help full?

996

What is factor analysis?

1139

describe the interaction table in sas di? : Sas-di

1031

What are differences between teradata and ansi session modes in teradata?

1175

where we cannot use sorter Transformation. if we use then we will not get correct data?

2199

Design time, run time. If you don't create parameter what will happen

1837

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2276

how could you generate test data with no input data? : Sas programming

1193

What is the difference b/w macros and prompt?

1137

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