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 tracing level? How many types of transformations supported by sorted input?

971

What is a rollup component?

1134

What is the function of aggregator transformation?

1083

What are the different options available for update strategy?

1003

What is the function of union transformation?

1134

What is meant by query override?

1059

What are different types of transformations available in informatica?

991

What is the difference between a connected look up and unconnected lookup?

966

What is the use of source qualifier?

1136

What is the function of look up transformation?

1123

What is the use of transformation?

996

What is the use of code page?

1091

What does reusable transformation mean?

1132

What is main use of mapplet?

1131

What is the way to execute pl/sql script using informatica mapping?

1603

Un-Answered Questions { Data Warehouse }

what is the difference between the report filter and report limit?

969

Can informatica load heterogeneous targets from heterogeneous sources?

1185

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

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

1079

Highlight the limitations of TPUMP Utility.

1111

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2202

What is difference between model & package?

1029

Can you explain surrogate key?

1038

What are all difference between business objects 6.5 and xi r2?

1031

What are the various file formats involved in reportnet?

976

What’s the use AWS redshift cluster Service?

What is the scenario which compels informatica server to reject files?

1070

What are consolidations?

908

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

2010

Explain the definition of normalized and denormalized view and what are the differences between them?

924

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