Skip to content
iExpertify

iExpertify

  • iExpertify
  • Netezza
  • SAP HR
  • SAP FICO
  • Free Courses
  • Courses
  • Checkout
  • My Profile

Category: Data Warehousing

Learn Data Warehousing in 30 days, just 1 hour a day

Oracle Enterprise stage

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

Published April 2, 2021
Categorized as Data Warehousing Tagged datastage

Slowly Changing Dimensions

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

Published April 2, 2021
Categorized as Data Warehousing Tagged datastage

Overview of Combining

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

Published April 2, 2021
Categorized as Data Warehousing Tagged datastage

Scheduling Batches

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

Published April 2, 2021
Categorized as Data Warehousing Tagged datastage

Overview of data process for combine and Partitioning

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

Published April 2, 2021
Categorized as Data Warehousing Tagged datastage

Combine data using the Funnel stage

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

Published April 2, 2021
Categorized as Data Warehousing Tagged datastage

Different stages

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

Published March 29, 2021
Categorized as Data Warehousing Tagged datastage

Create jobs

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

Published March 29, 2021
Categorized as Data Warehousing Tagged datastage

Untitled

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

Published March 29, 2021
Categorized as Data Warehousing Tagged datastage

Table definition and Schemas

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

Published March 29, 2021
Categorized as Data Warehousing Tagged datastage

Posts navigation

Newer posts Page 1 Page 2 … Page 9 Older posts

Recent Posts

  • Linux File Permissions -chmod
  • Grep Regex Example Linux
  • What is Data Modeling?
  • Input Redirection in Linux/Unix Examples
  • Snowflake Interview Questions

Technologies

  • AWS
  • Cloud
  • Data Warehousing
  • Full Course
  • interview
  • learn
  • Linux
  • Mobile
  • Programming
  • Temp-Datastage
  • Temp-Testing
iExpertify
Proudly powered by WordPress.