My e-Notes about DataScience, Machine Learning, Python, Data Analytics, DataStage, DWH and ETL Concepts

Breaking

InfoSphere DataStage Training





Datastage Essentials and Advanced Concepts

DataStgae Architecture
DataStage Clients - Administrator, Designer, Director, Repository
Types of Jobs
Design Elements of Parallel Jobs
Pipeline Parallelism
Partition Parallelism
Three-Node Partitioning
Job Design versus Execution
Architectural Setup Options
Setting Up a New DataStage Environment
Work on Projects and Jobs
Passive Stages
Import Table Definitions
Active Stages
Advanced Concepts When Building Jobs
The Business Use-Case Scenario
Assess a Previously Built Job
Assess Another Job
Create A Job From Scratch
Modify An Existing Job
Control the Jobs          
Testing
Extracting and loading data
Transforming and filtering data
Performing lookups in Datastage
Implementing ETL process in Datastage
Datastage jobs real-life solutions
Performance Analyzer and Resource Estimator utilities  
Slowly Changing Dimensions
DataStage Command Line ( dsjob n all )
DataStage job monitoring from Linux


For more detail, Kindly Click Here

2 comments:

  1. how to write total of a column at the bottom

    input data
    name,amt
    abc,1000
    def,1500
    ghi,1200
    jkl,1800
    mno,2500
    .
    .
    .
    .

    output
    input data
    name,amt
    abc,1000
    def,1500
    ghi,1200
    jkl,1800
    mno,2500
    .
    .
    .
    .

    total 12000

    ReplyDelete
  2. create a dummy column and give it value as a constant.It can be given as 1.Group by dummy and then get the sum of amt.Also create another column and populate it as 'total' in a separate file. At the end append this row to the source file.

    ReplyDelete

Disclaimer

The postings on this site are my own and don't necessarily represent IBM's or other companies positions, strategies or opinions. All content provided on this blog is for informational purposes and knowledge sharing only.
The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of his information.