Category: Data Warehousing

Reading Time: 5 minutes

Table name = dim 1 Write method = upset Upset order  = update then insert Compile and RUN In SQL… Continue reading Oracle Enterprise stage

Reading Time: 5 minutes

EX:- Suppose we have an customer Table, we have some fields which are frequently, ofliny,  slowly, Rarely, Rapidly changed Different… Continue reading Slowly Changing Dimensions

Reading Time: 8 minutes

Combining primary rows with Secondary rows based on key column values The stage that perform  Horizontal combining are Join Look… Continue reading Overview of Combining

Reading Time: 10 minutes

Step 1 Start DB/2 repository and Data stage Server (In the Task box, we have a Green colour icon, àRight… Continue reading Scheduling Batches

Reading Time: 4 minutes

Partitioning is the process of dividing an input data set into multiple segments, or partitions. Each processing node in your… Continue reading Overview of data process for combine and Partitioning

Reading Time: 6 minutes

It is a processing stage that supports n inputs and 1 output. Combining Source 1 and Source 1 without any… Continue reading Combine data using the Funnel stage

Reading Time: 2 minutes

DataStage provides three types of stages: File and Database Stages Dynamic Relational Stages Processing Stages Each stage has a set… Continue reading Different stages

Reading Time: < 1 minute

DataStage provides these types of jobs: Server Jobs: Run on the DataStage Server. Mainframe Jobs: Available only if you have… Continue reading Create jobs

Reading Time: 2 minutes

You can use DataStage Designer to view job categories, which serve to organize repository objects. You can view the following… Continue reading Untitled

Reading Time: 3 minutes

When transforming or cleansing data, you must define the data that you are working with. You define the data by… Continue reading Table definition and Schemas