 Related Questions Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling. Latest Answer : Dimension modelling means to define a datawarehouse architecture using any one of the availabale schemadimensionl modelling are 3 types 1. conceptual model 2. logical model3.physical modelconceptual model: gathering of all the requirementslogical ... a)Star Schema - Simple & Much Faster. Denormalized form. b)Snowflake Schema - Complex with more Granularity. More normalized form. Latest Answer : Is not star schema better performance wise (querying) as it has less no of join due to denormalized structure? Please clarify ... Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database. Latest Answer : Primary Key does not allow data duplications for actual source data. We cannot maintain historical data of each record using PK.SID acts as a primary key in target WH systems, that allows data duplications and maintains complete historical data along ... Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Consists of fields with numeric values. Dimension table - Table with Unique Primary Key. Load Latest Answer : __________________ _______________ ________________|_________________| |______________ ... Give the OS of the Server and the OS of the Client of your recent most project Latest Answer : server is unix and client machine i.e is ur machine where u design a job is windows xp professional ... Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance. Latest Answer : We can also use the Hash File stage to avoid / remove dupilcate rowsby specifying the hash key on a particular fileld ... What are other Performance tunings you have done in your last project to increase the performance of What are other Performance tunings you have done in your last project to increase the performance of slowly running jobs? Staged the data coming from ODBC/OCI/DB2UDB stages or any database on the server using Hash/Sequential files for optimum performance also for data recovery in case job aborts.Tuned the OCI stage for 'Array First we execute the jobs that load the data into Dimension tables, then Fact tables, then load the Aggregator tables (if any). Latest Answer : Simply by using "usage variyable" stage in job sequencers. ... The above might rise another question: Why do we have to load the dimensional tables first, then fact tables: As we load the dimensional tables the keys (primary) are generated and these keys (primary) are Foreign keys in Fact tables. Latest Answer : Dear User. A datawarehouse is a repository(centralized as well as distributed) of Data, able to answer any adhoc,analytical,historical or complex queries.Metadata is data about data. Examples of metadata include data element descriptions, data ... Read Answers (1) | Asked by : Kumar
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
