DataGenX - Atul's Scratchpad

Tuesday, November 17, 2015

Python points #1 - Syntax

Atul Singh November 17, 2015

Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.googl...

Monday, November 16, 2015

List DataStage jobs which used this Parameter

Atul Singh November 16, 2015

Open the DataStage Administrator Client Click on the Projects tab and select the project you would like to generate a list for. ...

Sunday, November 15, 2015

Shell Script

Shell Script Scenario #7 - Anagram words

Atul Singh November 15, 2015

Two words are called Anagram when you can rearrange the letters from one to spell the other. i.e. - Coat and Taco Heater and Reheat ...

Tuesday, November 10, 2015

Utilization

Check Memory Utilization by Datastage processes

Atul Singh November 10, 2015

While we are running lots of DataStage job on a Linux DataStage server or different environment are sharing the same server which cause th...

Monday, November 9, 2015

Scenario

DataStage Scenario #9 - Add Header & Trailer

Atul Singh November 09, 2015

Scenario: Design a job to add Header and Trailer to input data. Example Input: Atul Neeraj Anita A...

Monday, November 2, 2015

type

5 Tips For Better DataStage Design #4

Atul Singh November 02, 2015

1) While using AsInteger() function in datastage transformer always trim the imput column before passing it to function because if there a...

Friday, October 30, 2015

Upcase

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 =...

Wednesday, October 28, 2015

Use

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

tricks

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

tricks

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...

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.

Created By SoraTemplates