Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



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 18852

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

TCS,

3 10147

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

4 27185

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

1 6759

Can any body give the PDL with example?

Cap Gemini,

1 32015

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

2264

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

2157

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 5281

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

1 4809

What is audit table?

1 6682

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 6262

How we can create SAS USER DEFINED CODE?

2151

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

L&T,

1 4574

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,

2560

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 10358


Un-Answered Questions { Data Warehouse }

Why cognos scenario is used?

1110


what is a security filter?

1058


What does “tail –f” command do and what is its use as an Informatica admin.

1147


Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1092


What are the differences between sql override and update override?

1149


What are the types of facts in microstrategy?

1089


What will calendar procedure do?

1116


How do you add default rules in transformer?

1272


Explain when we use aggregate awareness function in designer?

1091


Which command using Query Analyzer will give you the version of SQL server and operating system ?

5179


Can Bo generates the Report from the cubical data Explain?

2087


Explain microstrategy logical primary keys?

1046


What is lookup change?

1113


where is the cache (lookup, index) created and how can you see it.

2067


What are stage variables and constants?

1199