 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 ... 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 ... Data in a Database is a) Detailed or Transactional b) Both Readable and Writable. c) Current. Latest Answer : Database data is in the form of OLTP and Data warehouse data will be in the form of OLAP. OLTP is for transactional process and OLAP is for Analysis purpose. ... 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 : __________________ _______________ ________________|_________________| |______________ ... Stage Variable - An intermediate processing variable that retains value during read and doesnt pass the value into target column. Derivation - Expression that specifies value to be passed on to the target Latest Answer : all r correct one only ... By using "ExcecSH" command at Before/After job properties. Latest Answer : You can specify the ExecDos Prompt in the after or before job routine. ... Link Partitioner : It actually splits data into various partitions or data flows using various partition methods . Link Collector : It collects the data coming from partitions, merges it into a single Latest Answer : server jobs mainly execute the jobs in sequential fashion,the ipc stage as well as link partioner and link collector will simulate the parllel mode of execution over the sever jobs having single cpu Link Partitioner : It receives data on a single input ... There are 3 types of views in Datastage Director a) Job View - Dates of Jobs Compiled. b) Log View - Status of Job last run c) Status View - Warning Messages, Event Messages, Program Generated Messages. Latest Answer : From what I know there are four views1> Status 2> Schedule3> Log4> Detail. ... Latest Answer : XML files can be read using FOLDER stage followed by XML input stage in server jobs. ... Latest Answer : You can insert the parameter values in a table and read them when the package runs using ODBC Stage or Plug-In stage and use DS variables to assign them in the data pipeline, or pass the parameters using DSSetParam from the controling job (batch ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
