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 are the data modeling tools you have used?(polaris)

4231

what is the difference between cardinality and Nullability?

3470

what is Forward,Reverse and Re_engineering?

QualTech,

2266

what is the meant by Normalization and de-normalization?

2731

what are the different Reporting and ETL tools available in the market?

3 13069

explain the methodology of Data Warehousing?(Polaries)

2034

what are the concerns of OLTP and DSS systems?

TCS,

2467

what is the difference between OLTP database and data warehousing database?

3 7321

what is data modeling?

2329

what is the difference steps for data modeling?

2616

what are the data modeling tools you have used?(polaris)

2014

what is the difference between cardinality and Nullability?

2961

what is Forward,Reverse and Re_engineering?

2217

what is the meant by Normalization and de-normalization?

2 8753

how would u estimate the size of Aggregator transform data and index cache?

2430

Un-Answered Questions { Data Warehouse }

Define update strategy?

1250

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

975

Explain security filter?

1058

Explain teradata architecture in detail with a diagram.

1135

What is the difference between a scan component and a rollup component?

1198

Does AWS Redshift use SQL?

What is sq transformation?

1181

Name the different sorting methods in datastage.

1071

Fact table is in normalized or de-normalized form?

983

Name the types of report?

977

What is the difference between static and dynamic conditions?

1099

Explain lookup transformation source types in informatica

1113

What does level of granularity of a fact table signify?

1110

Describe implicit attribute?

1031

What is ibm datastage flow designer?

1164

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