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 18738

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

TCS,

3 9996

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

4 27018

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

1 6698

Can any body give the PDL with example?

Cap Gemini,

1 31900

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

2190

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

2115

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 5141

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

1 4732

What is audit table?

1 6592

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 6129

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 4502

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,

2495

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 10152

Un-Answered Questions { Data Warehouse }

When we should use 'jobid' for commit table (Output table component??

9108

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2063

What are the approaches used by optimizer during execution plan?

911

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2283

What is difference macros and prompts?

2313

How to publish a package by running Java Script?

2091

write a query to retrieve the latest records from the table sorted by version(scd)

1074

Define report item?

1186

Explain what is the limit to the number of sources and targets you can have in a mapping?

1005

What differs when we choose the sorted input for aggregator transformation?

1032

9. What was the most complex type of report you dealt with?

2221

What problems have you faced while working with amazon redshift?

What are common programming errors committed in sas

1153

What are the advantages of cognos?

981

1. Explain your project.

2054

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