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 18720

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

TCS,

3 9987

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

4 27003

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

1 6696

Can any body give the PDL with example?

Cap Gemini,

1 31887

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

2185

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

2109

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 5129

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

1 4728

What is audit table?

1 6581

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 6114

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 4490

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,

2492

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 10133

Un-Answered Questions { Data Warehouse }

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2118

What do you mean by teradata intelliflex?

1099

How to implement security measures using repository manager?

1178

what are the deliverables?in your project?

2152

Which transformation is needed while using the Cobol sources as source definitions?

1174

What is the difference between odbc and drs stage?

1092

Can we create multiple integration service on single repository?

1187

What are the services provided in cognos 8?

1031

options available in sequence job to run,validate?

1316

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1263

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2126

How security is concerned with Reportnet? Explain its implementing steps.

2043

Difference between Data and Index Caches?

1137

how would u estimate the size of Lookup transform data and index cache?

2128

What is difference between symmetric multiprocessing and massive parallel processing?

1140

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