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?

1076

Differentiate between sessions and batches?

1073

What is the different lookup cache(s)?

1132

What is a repository manager?

1148

What is the use of an aggregator cache file?

1252

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

1128

What is the need for an etl tool?

1105

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

1 1629

Explain the shared cache and re-cache?

1169

What are the features of complex mapping?

1210

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

1021

What is a rank transform?

1148

What is meant by lookup transformation?

1191

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

1034

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?

1153

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

830

Explain what are fact, dimension, and measure?

1052

What is the extension of file to save template?

1060

How many steps etl contains?

995

What is vdl (view definition language) explain?

1106

Does Amazon redshift based on concept cluster?

How are the dimension tables designed?

1050

Explain pmcmd command usage in informatica

1191

How do you register plug-ins?

1005

Describe 5 ways to do a “table lookup” in SAS?

1193

How you can differentiate between connected lookup and unconnected lookup?

1111

what is the project environment(for each project the environment is same or different to different project)?

2284

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1100

Which is faster fastload or multiload?

1185

Write some methods to apply securities in framework manager model?

1172

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