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

why we use datawarehouse

HCL,

1986

why we need informatica

HCL,

2 13518

what is degenerated dimension table with scenario

HCL,

2 3680

Explain factlessfact table with scenario

HCL,

1 3383

What is confirmed dimension with scenario

HCL,

1 3433

Diffrence between static and dynamic cache

HCL,

2 6466

If u r using dynamic cache lookup port will be thier in thet which option u will select

HCL,

1 3439

What is souce qualifier transformation it is active or passive

HCL,

2 10448

What is an aggregator transformation? it is active why cant it be passive explain?

HCL,

3 18103

Diffrence between 7.1,8.1 and 8.6

HCL, Wipro,

3 11900

How the dimensions will be loaded?

HCL,

2127

How the facts will be loaded? explain

HCL,

2 8205

What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?

HCL,

1 5913

What is partioning?how many types of partinings are there

HCL,

2 7573

Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

HCL,

2 5576

Un-Answered Questions { Data Warehouse }

On which interface you will be working as a developer?

1052

What is the difference between %put and symbolgen? : sas-macro

1240

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2764

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1880

What is target designer and target load order?

1111

what is the difference between cardinality and Nullability?

3458

What are the common features of Redshift?

what is power prompt in cognos ep7series?what is the use of this?

3691

Can we take backup when the database is opened?

1059

State the working process of decimal_strip function?

2163

how many display types available in sas bi dashboard? : Sas-bi

1089

What is percent-to-total shortcut metric in microstrategy?

980

What are pdv and it functions?

1155

Explain the advantages of partitioned primary index in a query?

1028

Explain how to get the first 100 rows from the flat file into the target?

976

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