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

Explain what does level of granularity of a fact table signify?

967

What is ods (operation data source)?

1008

What is data validation strategies for data mart v?

1104

Explain what are fact, dimension, and measure?

1005

Explain why denormalization is promoted in universe designing?

969

What is latest version of power center / power mart?

1065

What is partitioning? What are the types of partitioning?

1179

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

939

What is an er diagram?

1061

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

937

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1028

Explain why should you put your data warehouse on a different system than your oltp system?

945

What is the difference between ods and oltp?

1034

Explain difference between view and materialized view?

971

How to design file watch jobs?

983


Un-Answered Questions { Data Warehouse }

How to limit the max no of rows retrieved in the report?

994


Explain ibm infosphere information server and highlight its main features?

1105


What are the automatic variables for macro? : sas-macro

1270


How many sessions of MAX is PE capable of handling at a particular time?

1094


What is the fact table?

1081


What are universe requirements?

1063


what is SDLC way of code development?

2050


How do u convert the columns to rows in datastage?

1209


What is resilience time?

1158


scenario where i can use only concurrent execution of workflow.

3189


What are data-driven sessions?

1229


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?

6513


How do you setup Lo-cockpit?

3178


What is the importance of the exception activity in datastage?

1082


In proc transpose and data step with arrays which one you pick?

3125