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
Learn Data Warehousing in 30 days, just 1 hour a day
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