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

Explain when do we analyze the tables? How do we do it?

1 1074

Explain what are the different methods of loading dimension tables?

1 1020

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

1 1028

Explain what is full load & incremental or refresh load?

1 1064

Explain what is the metadata extension?

1 1127

What are the main steps to build the data warehouse?

1 1184

Explain what is the difference between datawarehouse and bi?

1 1031

What is scd1 , scd2 , scd3?

1 1159

Explain the difference between oltp and olap?

1 1192

What is a data warehousing?

1 1253

What is a fact table?

1 1773

What is normalization, first normal form, second normal form, third normal form?

1 1045

Explain where do we use semi and non additive facts?

1 1084

What is cost benefit analysis (cba)?

1 1065

Explain what is the data type of the surrogate key?

1 1052

Un-Answered Questions { Data Warehouse }

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2266

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2438

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3664

explain in detail about type 3?

1091

Explain how to generate iqd file from framework manager?

1022

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

Write the unconnected lookup syntax and how to return more than one column.

1174

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2176

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2303

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1771

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2824

Hi friends, what are the new features in abinito3.0?

2860

What r the names of the reports that you prepared?

1032

What sort of existing documents should business analysts refer to when starting on a new project?

1078

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2084

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