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

which r the connectors used in san?

2188

what is the generated prompt,how can i use?

5 19812

how much memory space occupied real time project (roughly)?

2222

What is mean by tuning the report?

1 3268

what are they different types of report in BO?

6 32334

How do scheduling the report in BO XIR2? can you say what are they steps?

5 11922

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 27127

I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 9547

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

BirlaSoft,

5 15245

What are set operators in Oracle

Deloitte, Wipro,

3 17117

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

Deloitte,

9 19294

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

Deloitte,

21 40047

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 10747

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 5125

What is Target Update Override? What is the Use ?

Patni,

8 19832

Un-Answered Questions { Data Warehouse }

What sort of existing documents should business analysts refer to when starting on a new project?

1010

Explain about the data integration suite features?

945

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1169

Explain what is the difference between microstrategy and cognos reporting tool?

1072

in general which algorithms for used?

2026

What is data analysis? Where it will be used?

986

what is the difference between list and crosstab?

What is the difference between look-up file and look-up, with a relevant example?

1199

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2110

Compare microstrategy and tableau.

985

How the ipc stage work?

1127

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2065

What is Discover and Execute in XMLA?

2407

What is Session and Batches?

1108

Name the different types of Lookups in Datastage?

1256

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