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 15025

What is #DATASYNC error how to remove it?

IBM, TCS,

2 61833

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 5043

Can anybody explain what mean by Database Delegated Measures?

TCS,

2 21489

which domain is better in sas? clinical trails or banking

3 19248

what is the difference between proc means and proc tabulate?

Cognizant, CTS,

3 17062

what are the errors,warnings in datastage

Syntel, Wipro,

2714

What is Fastly Changing Dimension?

TCS,

6 14044

What is RCP?

TCS,

2 10917

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

Cap Gemini,

11 32033

What is the main difference between peek stage and copy stage

2 18826

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?

2071

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 9378

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

IBM,

3 8656

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24291

Un-Answered Questions { Data Warehouse }

Explain the importance of surrogate key in data warehousing?

1205

what is song in infrmatica...?

2255

What is star schema and snowflake schema?

1004

when will use SQL override in a lookup transformation?

2308

Can we get 1st record through Informatica(without sequence number).

1494

Compare cold fusion with other programming languages?

1021

How much data hold in one universe.

1006

what are the day to day activities of teradata DBA ?

5843

What is the difference between mapping parameter & mapping variable in data warehousing?

1005

What is lookup change?

1058

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2233

Explain what is data step?

1215

Explain how spool space is used.

1088

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1112

What is the syntax for m_dump in abinitio?

1640

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