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 5383

Parameter and variable differences

2070

Reusable transformation and shortcut differences

1847

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

1 2547

Implementation methodology

1723

Do you have knowledge in ralph kimball methodology

1 3543

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

1765

How do you recover rows from a failed session

1 3020

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

2054

Whats there in global repository

1701

Repository user profiles

1773

How do you set a varible in incremental aggregation

1902

Can you create a flatfile target

ABC,

3 4150

What did you do in source pre load stored procedure

1 2487

Scheduling properties,whats the default (sequential)

1966

Un-Answered Questions { Data Warehouse }

Explain the advantages of partitioned primary index in a query?

1034

How can you force the optimizer to use a particular index?

1074

How to execute the plsql procedure from the report by clicking with mouse?

1144

how many rows sorted in sort stage by default in server jobs

4005

what is a security filter?

1003

Differentiate between router and filter transformation?

1020

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2473

Describe the set operators in teradata.

1015

What are the different plug-ins stages used in your projects?

1085

whom do you report?

1937

explain the key concept of sas? : Sas-administrator

1011

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1119

What is a repository? And how to add it in an informatica client?

1156

Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

2193

What is index awareness in universe?

1039

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