Data Warehousing FAQs

Hi, Answer of question is as following. 1)Reject Port:it will contain all the rejected record,here rejection does not means those records which does not follow the join condition,here comes those reco...

Launch IR Studio--Tools---Connection--Create.

In datastage, we can use the External Filter stage, use the unix command head or tail to retrieve the particular lines from the flat file.

Using the SORT operation, we can retrieve the set of records from the flat file
 Sample command;

SORT FIELDS COPY
STOPAFT=10 (stop after 10th record)
SKIPREC=10 (skip first 10 records)
 

1. Conformed Dimensions
2. Junk Dimensions

There are 3 types of dimensions.type-1,type-2,type-3.

type-1:it maintains only latest information.

type-2:it maintains both previous and updated information.in this surrogate key comes into picture.most of the cases we use this type.

type-3:it maintains partial history of data.

Hi, The main diff between database and data warehouse------> DW 1)Its stores historical & Summarized d...

Company database contains all the current data. whereas the data warehouse of means data repository. Database stores all the data on which business runs but database repository contains the data that ...

By using sequence generator, Expression transformation and router T/R it will be possible.

Dimensions are like your lookup tables and Hierarchies forms Dimensions. Inside dimensions there exists hierarchies. Example Employee is a dimension , inside Employee dimensions there can be hierarchies such as Directors hierarchy, Managers Hierarchy and employees Hierarchy etc.,,

A dimention is nothing but a subject oriented meta data, just like hr section, employees section etc.  and the hierarchy is depend on the data source, like "hour glassmodel"Account dime...

replicate supports the component parallelism and broadcast supports data parallelism i.e fan-out,all-to-all.

Replication moves data to a specified target, usually at a specified time, and usually is usually defined by the ETL team or DBA. Broadcast moves data to targets in the system as needed, and is usuall...

-->create cube using ssas and deploy it.
-->connect sql server management studio
-->then connect sql server analysing services
-->right click on cube and click partition
----------------------------------------------------------------
like this we can partition the cube..

Any values in the fact table that dont join to dimensions are either considered degenerate dimensions or measures

INSERT FIRSTWHEN SAL > 25000 THENINTO special_sal VALUES(DEPTID, SAL)WHEN HIREDATE like ('%00%') THENINTO hiredate_history_00 VALUES(DEPTID,HIREDATE)WHEN HIREDATE like ('%99%') THEN...

We need to write shell script to run the job and write JIL on autosys to schedule the job

Autosys is a total job scheduling solution that allows you to define the event dependencies, time schedules alerts etc making it a complete data center automation tool. An AutoSys job is any single co...