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,

2370

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

1418

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,

1492

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,

1393

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

TCS,

1 17338

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 2601

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 2038

How many Key we can define in remove duplicate stage?

CTS,

1386

Un-Answered Questions { Data Warehouse }

What Amazon redshift built for ?

Explain when do we analyze the tables? How do we do it?

1000

What is workflow? What are the components of workflow manager?

1177

What is lookup table in etl testing?

1183

What are the components provided on node?

1042

Enlist few areas or real-time situations where informatica is required.

1085

What is cfapplication tag?

971

What are the string manipulation operators and functions associated with teradata?

1090

What is informatica?

1155

How to view every column and the columns contained in indexes in teradata?

1056

What is rank transformation?

991

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2041

What do you mean by derived metrics?

996

What are the automatic variables for macro? : sas-macro

1254

How can we store previous session logs?

1081

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