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 18570

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

TCS,

3 9828

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

4 26766

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

1 6606

Can any body give the PDL with example?

Cap Gemini,

1 31686

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

2108

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

2059

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 4993

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

1 4624

What is audit table?

1 6438

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 5952

How we can create SAS USER DEFINED CODE?

2028

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

L&T,

1 4390

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,

2436

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 9886

Un-Answered Questions { Data Warehouse }

How would you define the end of a macro?

1039

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

866

What is a dimensional model?

926

How much data hold in one universe.

927

Does redshift support unstructured data?

Different circumstance which drives informatica server to expel records?

915

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2400

How to reduce warnings?

897

How does a rank transform differ from aggregator transform functions max and min?

1143

for what purpose would you use the retain statement? : Sas programming

1017

How many project sources we can create in metadata?

1007

What is a security filter in microstrategy?

960

Explain BYNET.

947

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2336

what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1172

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