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 27894

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 7000

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

Patni,

1 8271

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 9934

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

2 5885

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

PCS,

4 12427

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 11334

which cache supports connected & un connected Lookup

Wipro,

1 5784

can we use sequential file as a lookup

Cognizant, Wipro,

7 24115

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 23593

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 8952

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 8717

Un-Answered Questions { Data Warehouse }

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767

In proc transpose and data step with arrays which one you pick?

3110

What would you change about your job?

2388

I need to set predefined condition. How I do this?

1014

Name the different sorting methods in datastage.

1050

How you can differentiate between connected lookup and unconnected lookup?

1062

What we will do with the universe for faster process?

982

What do you understand by user class in cognos?

952

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1581

What is the sortmerge collector?

1130

Explain attribute role?

1085

tell me 5 session failure in real time how can you solve that in your project?

2303

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

998

In the Primary Index, what is the score of AMPs that are actively involved?

1078

What are the functions used for character handling?

1259

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