1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


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 17222

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

TCS,

3 8722

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

 4 25031

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

 1 6003

Can any body give the PDL with example?

Cap Gemini,

1 30420

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

 1736

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

1662

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 3993

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

 1 3895

What is audit table?

 1 5317

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 4790

How we can create SAS USER DEFINED CODE?

 1616

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

L&T,

1 3680

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,

1975

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 8428

Un-Answered Questions { Data Warehouse }

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

1558

How to create Index to the table in the universe designer and how it improves the Query performence

2124

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1534

How were the reports scheduled and how to resolve unexecuted documents?

2223

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

506




what are several options for creating reports in web report studio? : Sas-bi

634

Can we collect statistics on multiple columns?

570

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

555

Why do we need informatica?

554

Which statement does not perform automatic conversions in comparisons?

1205

What are ETL Tools?

669

can anybody mail me the FAQS for hyperion essbase amd planning

5194

What are the types of hierarchies?

560

if collect stats but it show low confidence why?

1192

Why is business intelligence (bi) important in data warehousing?

536

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