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

How can we remove the duplicates from flat file source?

1049

Differentiate between sessions and batches?

1027

What is the different lookup cache(s)?

1096

What is a repository manager?

1100

What is the use of an aggregator cache file?

1210

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1069

What is the need for an etl tool?

1078

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 1573

Explain the shared cache and re-cache?

1128

What are the features of complex mapping?

1171

What is a filter transformation and why it is an active one?

980

What is a rank transform?

1095

What is meant by lookup transformation?

1123

What are the new features of informatica 9.x developer?

981

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1105

Un-Answered Questions { Data Warehouse }

Differentiate between a repository server and a powerhouse?

1130

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1876

What is scd1 , scd2 , scd3?

1095

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2171

What exactly do you understand with the term data processing and businesses can trust this approach?

1120

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1073

What is scd type 1 and 2.

897

Differentiate between router and filter transformation?

1020

What is difference macros and prompts?

2319

Explain oject manager?

1015

What are the data types does SAS contain?

1128

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2018

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1901

What is apt_config in datastage?

1149

What happens when we provide null key to sort, merge and pbks in Abinitio ?

1690

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