UpCase and DownCase String Function : DataStage Transformation
Atul Singh
October 30, 2015
Downcase(column): This function converts all the input character to LOWER case where input can be in any case. input =...
Friday, October 30, 2015
Wednesday, October 28, 2015
Left and Right String Function - DataStage Transformation
Atul Singh
October 28, 2015
Today, we will discuss two more datastage transformer functions - Left & Right. These two functions use to get or cut the string fro...
Tuesday, October 27, 2015
5 Tips For Better DataStage Design #3
Atul Singh
October 27, 2015
• Stage Variables allow you to hold data from a previous record when the next record, allowing you to compare between previous and current...
Monday, October 26, 2015
Linux One Liners #3
Atul Singh
October 26, 2015
For more - CLICK HERE Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datag...
Friday, October 23, 2015
authfile in dsjob command
Atul Singh
October 23, 2015
While working on Datastage CLI commands, in some cases when you are working on server which is having multiple DataStage server install Or ...
Wednesday, October 21, 2015
DataStage Scenario #8 - Populate date between given two
Atul Singh
October 21, 2015
Scenario : Design a job with 2 job parameters - 1. Start Date ( DD-MM-YYYY ) 2. End Date ( DD-MM-YYYY ) Read the parameter a...
Tuesday, October 20, 2015
NULL behavior in datastage transformer
Atul Singh
October 20, 2015
NULL - It is always a challenge for developers or architect while dealing with NULL in data. Every projects need some base rules to process...
Friday, October 16, 2015
Datastage job processes type at server side
Atul Singh
October 16, 2015
When we are running datastage jobs in the designer, director, by command line or by any third party tool, it invoked 4 type of process at ...
Thursday, October 15, 2015
Behavior of Multi-Instance job in Director Client
Atul Singh
October 15, 2015
Multi-Instance Job: DataStage is supporting Multi-Instance jobs which can be run at same time with different invocation i...
Wednesday, October 14, 2015
DataStage Scenario #7 - Count data in each column
Atul Singh
October 14, 2015
Count the total rows and cells which is having some data in it. Input: col1 col2 col3 a {NULL} b ...
Tuesday, October 13, 2015
5 Tips for better DataStage Design & Administration #2
Atul Singh
October 13, 2015
1. In a DataStage server environment with more than one version of DataStage installed in the dsjob command you must specify the server nam...
Monday, October 12, 2015
How to Encrypt Password for Datastage ?
Atul Singh
October 12, 2015
As datastage user, we need lots of scripts help our daily jobs, most of these scripts need authenticate by datastage engine, that means...
Thursday, October 8, 2015
Shell Script for listing out Running Datastage jobs
Atul Singh
October 08, 2015
This script is using the logic/commands from Get currently running DataStage jobs (link) . You can run this script in your linux terminal ...
dsjob #3 - Managing Datastage Jobs from Command Line
Atul Singh
October 08, 2015
0. Sourcing DSHOME in Windows or Linux In Windows - Add the DSENGINE/bin path to Windows PATH In Linux - Add the DSENGINE/bin pat...
Wednesday, October 7, 2015
Shell Script Scenario #2 - Solution
Atul Singh
October 07, 2015
You can find other scenarios HERE ================================================================================== ==============...
Tuesday, October 6, 2015
dsjob #2 - Managing Datastage Jobs from Command Line
Atul Singh
October 06, 2015
Continued from dsjob - Managing Datastage Jobs from Command Line #1 Listing Projects, Jobs, Stages, Links, and Parameters : We ...
Sunday, October 4, 2015
Hashing & Sorting Criteria in stages
Atul Singh
October 04, 2015
As we all aware about the best partitioning method is Round Robin but this method distribute the whole data to all the partition irrespecti...
dsjob #1- Managing Datastage Jobs from Command Line
Atul Singh
October 04, 2015
Datastage Command Line Interface: The DataStage CLI comprises three groups of commands, those concerned with running DataStage Jobs, tho...
