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 teradata vs. Redshift?

1039

how to export or import the jobs in .ISX file

1217

Explain the aggregator transformation?

1188

Explain the use of aggregator cache file?

1267

What does role playing dimension mean?

1056

What do you mean incremental aggregation?

1095

How many number of sessions can one group in batches?

1184

What are the prerequisite tasks to achieve the session partition?

1270

Briefly define reusable transformation?

1141

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1342

What is target load order?

1268

What the difference is between a database, a data warehouse and a data mart?

1161

What is joiner transformation?

1020

How can repository reports be accessed without sql or other transformations?

1238

What is olap (on-line analytical processing?

1083

Un-Answered Questions { Data Warehouse }

Explain why are oltp database designs not generally a good idea for a data warehouse?

1044

Where do the datastage jobs get stored?

1229

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

1063

On which Dimension Table you implemented SCD Type in your Project

2066

What are the different transaction levels available in transaction control transformation?

1228

what are passthrough functions?

967

How would you identify a macro variable? : sas-macro

1032

What is the difference between in process and inter process?

1163

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1091

Explain the different lookup methods used in informatica?

1055

How do you add default rules in transformer?

1241

What is Redshift Spectrum?

What are the components of the report studio?

1196

Explain a relation schema and a relation?

1125

What is the roundrobin collector?

1108

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