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

How will u remove header record? How will u remove tailer record?

EDS, Polaris,

5 27895

Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?

2 11444

What is DSS?? (Defination of DSS)

2 7004

What is maximum number of promts we can give in a BO report?

Patni,

1 8274

How Union Transformation is an Active Trans?

6 20286

Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?

Barclays,

2 9936

What is the use of linling the universes?Thanks in advance

2 5886

What is a surrogate key?Why we use it in a mapping?Pl give an example.

PCS,

4 12429

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 11338

which cache supports connected & un connected Lookup

Wipro,

1 5789

can we use sequential file as a lookup

Cognizant, Wipro,

7 24121

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

Wipro,

1 7301

what is Audit table?Have u use audit table in ur project?

Accenture, Wipro,

3 23595

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

Wipro,

2 8953

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

Wipro,

2 8720

Un-Answered Questions { Data Warehouse }

what are the special features in cognos reportnet?

1061

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2005

What are iconv and oconv?

1245

How you can differentiate between connected lookup and unconnected lookup?

1063

Explain what are non-additive facts in detail?

1035

what do the pad and dim functions do? : Sas programming

1026

What do you mean by staging area?

972

How we can create indexes after completing the loan process?

1211

What are the design features involved in teradata?

1058

Define update strategy?

1230

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2421

what is $$$$?

2160

Explain amp in teradata?

1085

How do you start developing a datastage project?

1108

What is model?

969

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