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

-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?

IBM,

1 16395

----------0Diff b/w Report Functions and Database functions?

IBM,

1 4163

----------------------What are the User Securities?

IBM,

1856

---------------Tell me about DWH Concepts?

Bank Of America,

2150

--------------Diff b/w ODS and OLAP?

Bank Of America,

3207

---------- Purpose of Factless Facttable?

Bank Of America,

2 7985

----------------What is meant by DSS?

Bank Of America,

1 6530

----------------------Diff b/w MOLAP and ROLAP?

Bank Of America,

4 7610

-------What are the Adv of Star Schema and Snow Flake Schema?

Bank Of America,

4 13690

-----------Types of Fact Tables?

Bank Of America, CTS,

6 22067

---------------Can we use more than 1 Fact table ?

Bank Of America,

2 6998

-------------What is a Conformed Dimension?

Bank Of America,

3 8058

---------------Describe OLAP Reporting and RDBMS Reporting?

Bank Of America,

2105

-----------Diff b/w OLAP and RDBMS?

Bank Of America,

2046

---------------What is Dimension?

Bank Of America,

2 6250


Un-Answered Questions { Data Warehouse }

Explain bmdp procedure?

1044


What do you mean by filter transformation?

953


What are the batches and it’s details?

974


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4111


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6492


What are the implications?

1717


What is the need of an ETL tool?

1103


What is the function that transfers a string into a decimal?

1158


Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

902


I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2154


What is difference between informatica power mart and power center?

1007


How to do performance tunning of reports?

2319


what is sas application server? : Sas-di

1083


After the complete generation of a report who will test the report and who will analyze it?

984


What are the difference between ceil and floor functions in sas?

1354