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

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

TCS,

3 18724

Can we use Round Robin for aggregator?is there any benefit underlying?

TCS,

3 9989

How to add zero "0" before record in a field?

4 27004

Where in report Studio's property pane can I find NoDataHandler?

1 6696

Can any body give the PDL with example?

Cap Gemini,

1 31893

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2186

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

2110

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 5132

when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.

1 4729

What is audit table?

1 6584

Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.

4 6119

How we can create SAS USER DEFINED CODE?

2096

i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?

L&T,

1 4491

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

L&T,

2493

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

L&T,

5 10136

Un-Answered Questions { Data Warehouse }

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1385

Explain a mapping, session, worklet, workflow, mapplet?

1107

What are Aggregate tables?

1175

SCD2 will work on only dimension tables as well as fact Table?

1401

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

1079

When do we analyze the tables? How do we do it?

960

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8202

What is the model filter?

1017

Which command is used to save logs in the external file?

1099

What does edp stand for?

1157

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

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375

What is mapplet in informatica?

1057

how many maximum session supports to multiload in teradata ??

2118

Explain fact relation?

1014

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