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

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 5381

Parameter and variable differences

2066

Reusable transformation and shortcut differences

1846

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 2545

Implementation methodology

1723

Do you have knowledge in ralph kimball methodology

1 3539

According to his methodology what all you need before you build a datawarehouse

1762

How do you recover rows from a failed session

1 3017

Sequence generator, when you move from develoment to production how will you reset

2052

Whats there in global repository

1700

Repository user profiles

1770

How do you set a varible in incremental aggregation

1898

Can you create a flatfile target

ABC,

3 4146

What did you do in source pre load stored procedure

1 2485

Scheduling properties,whats the default (sequential)

1965

Un-Answered Questions { Data Warehouse }

How would you format some text using css to be verdana and bold?

1083

What is scd type 1 and 2.

897

What is a datastage job?

1020

What are the co> operating system’s assorted library of integrated components?

1122

Select the AWS service which is nosql database and serverless, minimal latency ?

How to join three sources using joiner? Explain though mapping flow.

1154

What is abinitio?

1179

Explain the definition of normalized and denormalized view and what are the differences between them?

933

Explain ddl (data definition language)?

1017

Explain amp in teradata?

1091

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1279

What can we do with datastage director?

1245

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

968

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

979

Explain can a dimension table contains numeric values?

972

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