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

Different sorts of metadata that stores in the storage facility?

1011

How might you approve all mappings in the archive all the while?

1018

Quickly characterize reusable change?

1120

What do you mean by channel change?

1047

What is abap? What are idocs?

965

How can we use external procedural logic in informatica?

924

Do we need an etl tool?

1009

What is etl process. How many steps etl contains explain with example?

959

What is a staging area? What is the purpose of a staging area?

885

What are vaious etl tools in the market?

1004

What are the measure objects?

1202

What are the different types of transformation available in informatica.

1105

Explain what are the different types of transformation available in informatica.

1149

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

How to do unit testing in informatica? How to load data in informatica ?

1120

Un-Answered Questions { Data Warehouse }

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

779

What is "method/1"?

1060

What is the difference between microstrategy and cognos reporting tool?

995

What is joiner transformation?

1010

Difference between informatica vs ab initio?

1310

do you prefer proc report or proc tabulate? Why? : Sas programming

984

What is the use of target designer?

1054

What is zero-foot print?

1019

What are differences between different versions of co-op?

1208

What is informatica worklet?

1067

What are the primary usages of datastage tool?

1075

How to include or exclude specific variables in a data set?

1120

Explain about hash partitioning?

1000

How can I load my data into Amazon Redshift from different data sources like Amazon RDS, Amazon DynamoDB and Amazon EC2?

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1036

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