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 2826

what is combinability and non combinability?

2 16057

Why we need datasets ratherthan sequential files?

5 32133

what is the diff between sequential file and fileset stages?

3 26952

what is sparse lookup?

IBM,

7 31911

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

1 5435

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 8859

how do you validate sas program?

Accenture,

6 14248

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

3 6691

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

HCL,

4 12157

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

2 5858

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

Accenture,

2 10307

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?

2079

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

Accenture,

2 12425

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

4449

Un-Answered Questions { Data Warehouse }

What is the effect of dls on microstrategy?

1066

What is run-group processing?

1248

What is a compound attribute in microstrategy?

1098

What are stage variables and constants?

1205

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10733

What is a staging area? Do we need it? What is the purpose of a staging area?

1060

Can you use flat files in Mapplets.

2717

What is the difference between informatica and datastage?

1310

Explain a relation schema and a relation?

1183

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1253

What is smp and mpp platforms?

1041

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2191

Describe stream connector?

1369

Which commands are used to import and export the datastage jobs?

1473

Explain what are non-additive facts?

1083

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