Tag: datastage

Reading Time: 3 minutes

In the Datastage Director, we can: run, schedule and monitor jobs view job status, logs and schedules filter the displayed… Continue reading Introduction to DataStage Director

Reading Time: 12 minutes

Oracle Database Select database Category There are 4 new stages in the database That is in 8 version I way… Continue reading Oracle stage properties

Reading Time: 3 minutes

Features of Data Stage Any to Any Platform Independent Node Configuration Portion Parallelism Pipeline Parallelism Any to Any Reads the… Continue reading Runtime Architecture

Reading Time: 5 minutes

What is the Unstructured Data? Unstructured data is an information that does not have a predefined data model or does… Continue reading Excel Data in Datastage (unstructured datastage)

Reading Time: 4 minutes

In general, we have 4  Architecture Simple ODS  – Operations Data source NDS – Normal  Data source Integrity    we… Continue reading Datastage data Architecture

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