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

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

CTS,

8 15386

What is #DATASYNC error how to remove it?

IBM, TCS,

2 62011

I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 5142

Can anybody explain what mean by Database Delegated Measures?

TCS,

2 21691

which domain is better in sas? clinical trails or banking

3 19422

what is the difference between proc means and proc tabulate?

Cognizant, CTS,

3 17303

what are the errors,warnings in datastage

Syntel, Wipro,

1 2803

What is Fastly Changing Dimension?

TCS,

6 14289

What is RCP?

TCS,

2 11089

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

Cap Gemini,

11 32445

What is the main difference between peek stage and copy stage

2 18967

I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

1 2133

There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?

BitWise,

2 9525

what are fact tables and dimension tables? give example assuming one table.

IBM,

3 8823

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24472

Un-Answered Questions { Data Warehouse }

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1964

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2069

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

Are you involved in writing the inferential analysis plan? Tables specifications?

4021

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1245

Explain about a time when you discovered a more efficient way to do a work task?

1224

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

1673

What is the difference between business requirement document and use case document.

1086

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1105

What r the names of the reports that you prepared?

1032

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4196

what are the names of the reports that you prepared?

1203

how many reports have u created ? explain a few.

2162

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

848

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