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.

1631

What are the differences between oltp and olap?

923

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

890

Differentiate between reusable transformation and mapplet.

1031

Why update strategy and union transformations are active?

991

What is meant by target load plan?

916

How to join three sources using joiner?

1032

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

1060

What are the differences between source qualifier and joiner transformation?

996

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

1095

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

899

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

1176

How do you remove duplicate records in informatica?

1 1304

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

1808

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

1101

Un-Answered Questions { Data Warehouse }

What does the RUN statement do?

1257

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

2061

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1034

Could any one explain me how to create cascading prompts?

988

Explain two-tier connection?

891

Mention the difference between ceil and floor functions in sas?

1103

Give me any example of semi and non additive measures?

902

Can we create a node as a gateway node and the same node can be assigned to a grid?

1028

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

725

Can we test the report other than manual testing?

2109

Which is the database redshift is using?

Where we use surrogate key explain with example?

1047

explain about unit testing? in real time?

2140

What is node? How many nodes and amps used in your previous project?

1063

What is many-to-many dimensional model in datawarehousing ?

872

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