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 granularity? Please explain with example

IBM,

1 2155

Explain me ETL project architecture in Detail?

Infosys,

2367

How to load a Dimension ? and how to load a fact table?

1416

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

Wipro,

1 2481

What are the limitations for memory allocation for SAS variables

Signetsoft,

1491

What is maximum number of rows and cols can be handled in SAS?

Signetsoft,

1587

What is maximum storage capability of SAS?

1423

: and & modifiers.

Oracle,

1391

Describe step by step the process of creating tag and savefile for migration

TCS,

1 17337

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538

Target increases every day even though no new record was inserted

Accenture,

1580

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

Virtusa,

1 2599

how to run a sequential file stage in parallel if the stage is used on the TARGET side

Virtusa,

1746

Which is the best place to learn Informatica Powercenter Online Training?

1 2037

How many Key we can define in remove duplicate stage?

CTS,

1383

Un-Answered Questions { Data Warehouse }

What is InformaticaPowerCenter?

1136

What Is Snow Flake Schema?

1204

can anyone explain me about retail domain project in informatica?

7946

Explain the features of connected and unconnected lookup.

935

how do u really know that paging to disk is happening while u are using a lookup transform?

1981

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2057

Explain how to schedule the report in b.o?

1049

Is there any other repository domains rather than universe, security, document?

1046

What is oci?

1301

What is the maximum number of dml can be coded in a multiload script?

1107

How will you enable or disable caching in the system level and table level?

894

Name the command line functions to import and export the DS jobs?

1155

explain abt ur project architecture?

2193

Is olap services sold as a separate product?

915

State the limitations where we cannot use joiner in the mapping pipeline?

1066

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