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

What is difference between force_error & force_abort? How to use in abinitio graph?

IBM, TCL,

2 10423

What is the best way of creating huge test feeds ? How to use in abinitio graph?

IBM, TCL,

1 4287

Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?

IBM, TCL,

3 12917

What is difference between API

CitiGroup, IBM, TCL,

2 11756

What is the significance of record required indicator of Join component ? How to use in abinitio graph?

IBM, TCL,

2 6327

What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

IBM, TCL,

3461

When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

IBM, TCL,

2448

Layout - L1*, L1 - What is the difference ? How to use in abinitio graph?

IBM, TCL,

1 7587

What is standard environment ? How to use in abinitio graph?

IBM, TCL,

1 7770

How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?

IBM, TCL,

2 8604

why Skew should always be 0 ? How to use in abinitio graph?

IBM, TCL,

1 7017

You can ask about different vector functions. How to use in abinitio graph?

IBM, TCL,

5545

What mpjret contains ? How to use in abinitio graph?

IBM, TCL,

2 6789

Can you use scan to generate sequence number ? How to use in abinitio graph?

IBM, TCL,

2 9003

How you can generate surrogate key? How to use in abinitio graph?

IBM, TCL, Torry Harris,

2 10739

Un-Answered Questions { Data Warehouse }

What is dimensional table?

1072

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2041

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2282

How do you set a varible in incremental aggregation

1895

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2283

----------------Diff b/w Dimensional modeling and Relational modeling?

15014

define sparse cube?

Differences between connected and unconnected lookup?

1224

What is a dimension table?

1072

While creating table my dba has fallback or no fallback in his ddl. What is that?

1188

How does a sorter cache works?

1075

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

1010

What is the difference between view filter and report filter?

931

Does redshift support unstructured data?

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2278

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