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 General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 10365

Difference between DSS & OLTP?

IBM,

6 52015

Explain grouped cross tab?

2673

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 19275

How many repositories can we create in Informatica?

Informatica,

14 29436

What is surrogate key?

IBM, Informatica,

5 22763

What is difference between Mapplet and reusable transformation?

UST,

3 7716

What is aggregate awareness?

2 8121

Explain reference cursor?

2225

What are parallel querys and query hints?

2276

DWH architecture?

6 18911

What are cursors?

4 9413

Advantages of de normalized data?

2 11540

What is operational data source (ODS)?

2 10697

What is meta data and system catalog?

2347


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is difference between query studio and report studio?

1049


Explain the main difference between inmon and kimball philosophies of data warehousing?

1016


What is the difference between ods and oltp?

1079


Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1068


What is the difference between a primary and secondary actor in use case modeling?

1129


what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2296


How to generate the cubes in framework manager?

1098


Suppose we want to display zero when null values coming to report how can we do that?

982


Can we have multiple application.cfm file in an application?

998


ware house management system is used?

1055


Explain what are the mapping paramaters and maping variables?

1138


Explain where do we use semi and non additive facts?

1063


Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

1010


What is Discover and Execute in XMLA?

2467


What is the difference between aggregate table and materialized view?

1139