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

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1710

What are the differences between oltp and olap?

972

What are the types of schemas we have in data warehouse and what are the difference between them?

941

Differentiate between reusable transformation and mapplet.

1096

Why update strategy and union transformations are active?

1042

What is meant by target load plan?

974

How to join three sources using joiner?

1115

How do you update the records with or without using update strategy?

1117

What are the differences between source qualifier and joiner transformation?

1062

How do you convert single row from source into three rows into target?

1157

What are the types of schemas we have in data warehouse.

963

Why update strategy and union transformations are active? Explain with examples.

1240

How do you remove duplicate records in informatica?

1 1386

How do you load alternate records into different tables through mapping flow?

1872

How do you load first and last records into target table?

1159

Un-Answered Questions { Data Warehouse }

Define catalog in cognos and write its various types?

1183

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1197

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2032

Explain the versions of reportnet?

990

What is xml source qualifier transformation in informatica?

1217

How to implement security measures using repository manager?

1178

Explain lookup transformation source types in informatica

1098

how to merge 2 crosstabs thans

2641

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2024

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1322

Can microstrategy desktop access sap data?

948

What is is a star schema?

1175

What is the difference between connected and unconnected stored procedures?

1082

what is the use of server manager?

2137

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

2009

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