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 the ab initio etl tool in high level?

1155

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

1130

What are the features of ab initio?

1122

How does the bre work with the co>operating system?

1109

What is a partition?

1177

Can you explain the performance and scalability of co> operating system?

1140

What are “business rules” in ab initio business rules environment (bre)?

2032

How co>operating system integrates with legacy codes?

1187

What is ab initio enterprise meta>environment (eme)?

1553

What are the fundamental blocks of co> operating system of ab initio?

1276

What is the ab initio business rules environment (bre)?

1185

What is conduct>it?

1124

Explain data flow graph with an example?

1145

What is is a data flow graph?

1134

Describe the evaluation of parameters order in ab initio?

1540

Un-Answered Questions { Data Warehouse }

What are the message flows?

994

Describe primary index in teradata. And what are the available primary index types?

1012

What is the need for an etl tool?

1081

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1788

What is the cumulative sum and moving sum?

1200

What is union transformation in informatica?

1154

What is informatica architecture?

1077

How can one find bugs in job sequence?

1433

what is the use of structures?how many nodes can u create in a structure?

2250

For clinical entire study how many tables will create approx?

1982

Explain dimensional modelling?

990

What are the limitations of amazon redshift?

Explain how you can debug and test your SAS program?

1026

Explain what is the advantages data mining over traditional approaches?

1038

What are the different log files in obiee?

974

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