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 14998

What is #DATASYNC error how to remove it?

IBM, TCS,

2 61821

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 5032

Can anybody explain what mean by Database Delegated Measures?

TCS,

2 21477

which domain is better in sas? clinical trails or banking

3 19231

what is the difference between proc means and proc tabulate?

Cognizant, CTS,

3 17052

what are the errors,warnings in datastage

Syntel, Wipro,

2706

What is Fastly Changing Dimension?

TCS,

6 14014

What is RCP?

TCS,

2 10906

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

Cap Gemini,

11 32005

What is the main difference between peek stage and copy stage

2 18813

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?

2066

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 9360

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

IBM,

3 8635

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24275

Un-Answered Questions { Data Warehouse }

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1081

Explain what is the difference between stop and abort?

1051

How to startup obiee in linux?

897

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1917

what is sas data set?

1110

Can the administrator easily maintain and manage microstrategy intelligence server?

1020

what are the deliverables?in your project?

2156

what are the devoleper roles in real time? plz tell i am new to datastage....

2165

Where do we use semi and non additive facts?

996

List out teradata data types?

1019

EXL informatica Questions

1396

Is AWS redshift is one of the RDS in AWS or is it Relation Database?

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2106

What is the basic syntax style in SAS?

1176

How to eliminate duplicate rows from flat file?

946

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