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 are active transformations? Name them.

1 2631

Can you use flat files in Mapplets.

2663

How many transformations can be used in mapplets.

1949

Can a joiner be used in a mapplet.

1 4127

What are active transformations.

1660

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 2849

Global and Local shortcuts. Advantages.

2044

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 2778

Have you worked with/created Parameter file

1670

What's the layout of parameter file (what does a parameter file contain?)?

Cognizant,

2396

Why do you use Mapping Parameter and mapping variable?

1776

Where do you create/define mapping parameter and mapping variable?

1 3344

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

IBM,

1 3712

Slowly changing dimensions, types and where will you use them

1724

What are the modules in Power Center

1690

Un-Answered Questions { Data Warehouse }

What happens when a session fails and you click on recover?

1126

What is primary and backup node?

1140

Explain sessions and how many types of sessions are there?

1018

Can you brief about the Data warehouse project you worked on?

2386

How might one distinguish in the case of mapping is right or not without associating session?

1139

What is the roundrobin collector?

1104

What are the joins in teradata?

1024

How do we execute sql file on redshift?

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2269

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1166

What does PROC print, and PROC contents do?

1243

Explain about etl data integration software?

898

What are the difference types of stages?

1223

What is a sorter transformation?

1110

What do you mean by parsing?

1123

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