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?

1047

Differentiate between sessions and batches?

1026

What is the different lookup cache(s)?

1095

What is a repository manager?

1099

What is the use of an aggregator cache file?

1206

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

1066

What is the need for an etl tool?

1074

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

1 1569

Explain the shared cache and re-cache?

1127

What are the features of complex mapping?

1167

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

974

What is a rank transform?

1093

What is meant by lookup transformation?

1118

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

976

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?

1101

Un-Answered Questions { Data Warehouse }

Explain differences between star and snowflake schemas?

1166

What are the difference between sas functions and procedures?

1162

Explain what is the difference between native sql and cognos sql?

1015

Performance tuning( what you did in performance tuning)

1998

Which commands are used to import and export the datastage jobs?

1415

Explain compound key?

991

What is database exceptions in teradata?

958

What is informatica worklet?

1073

Is redshift can be used with AWS RDS?

Why update strategy and union transformations are active?

1052

Ist the schema that a data warehouse system can implements.

947

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2350

What is the use of dimensional modeling in data warehousing?

989

What are the implications?

1721

Explain about etl data integration software?

897

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