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 2302

Explain me ETL project architecture in Detail?

Infosys,

1 2426

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

1 1493

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 2577

What are the limitations for memory allocation for SAS variables

Signetsoft,

1 1572

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

Signetsoft,

1 1709

What is maximum storage capability of SAS?

1 1502

: and & modifiers.

Oracle,

1 1477

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

TCS,

1 17524

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

1 1605

Target increases every day even though no new record was inserted

Accenture,

1 1652

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 2693

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

Virtusa,

1 1816

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

1 2134

How many Key we can define in remove duplicate stage?

CTS,

1 1460

Un-Answered Questions { Data Warehouse }

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2175

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

How to add default rules in transformer?

1284

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

EXL informatica Questions

1460

What is aggregate table and aggregate fact table ... Any examples of both?

1118

Write the unconnected lookup syntax and how to return more than one column.

1174

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2492

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

846

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2259

What is the difference between business requirement document and use case document.

1081

What is the purpose of Dataware Control?

1120

What is rollup component?

1331

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1200

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