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 18734

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

TCS,

3 9993

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

4 27013

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

1 6698

Can any body give the PDL with example?

Cap Gemini,

1 31896

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

2188

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

2114

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 5139

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

1 4731

What is audit table?

1 6590

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 6125

How we can create SAS USER DEFINED CODE?

2102

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

L&T,

1 4497

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,

2494

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 10146

Un-Answered Questions { Data Warehouse }

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1927

What do the SAS log messages "numeric values have been converted to character" mean?

1384

What are the functions involved in shared information architecture?

1073

Explain the difference between holap and rolap?

983

How to Extract data from multiple legacy systems?

1125

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1999

What is drill down and slicing and dicing whats the difference between them?

1073

What is microstrategy desktop?

1030

What is difference between webi and infoview?

1265

What is enterprise data warehousing?

1050

Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

939

What is the function of etl when used in data warehousing?

963

Can we collect statistics on table level?

1037

how get the grand total in master-detail report?

2236

what is the difference between unique key and primary key? : Sas-di

1133

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