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
how to write total of a column at the bottom
ReplyDeleteinput 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
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