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 a mapping?

988

What are materialized views & where do we use them?

998

State the differences between shortcut and reusable transformation

1056

Explain about round-robi?

1148

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1074

What is a materialized view log?

998

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

933

What are snapshots?

980

What are the differences between sql override and update override?

1100

What is partitioning? Explain about round-robin, hash partitioning.

964

Explain about hash partitioning?

1000

How many types of transformations supported by sorted input?

1222

How to fine tune mappings?

941

What is a mapping, session, worklet, workflow, mapplet?

985

What is etl process?

936

Un-Answered Questions { Data Warehouse }

Can you explain the advantage of using shortcuts?

1029

What is a core dimension?

1069

What is the enterprise class platform architecture of cognos 8?

1029

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1511

What is an olap designer?

967

What is meant by drill down?

977

Explain what would you consider as your biggest achievement and why?

984

what is the role of skipcheck in tm1?

EXL informatica Questions

1390

Explain difference between view and materialized view?

961

explain what is data set in sas? : Sas-administrator

992

Is olap services sold as a separate product?

921

Highlight all the modes that are present under Confidence Level.

971

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1126

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3346

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