Search found 63 matches
- Mon Dec 08, 2014 8:27 am
- Forum: General
- Topic: Architect certification
- Replies: 2
- Views: 2539
Architect certification
Hi Folks So its been almost 9 years working on different versions of Datastage and gaining a lot of understanding on Data Modelling stuff. I am now thinking of using all my experience and expertise to jump into the bandwagon of ETL Architect / BI Architect / Datawarehouse Architect. However , I woul...
- Wed Feb 12, 2014 9:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Changing date format from YYYY-MM-DD to DD-MON-YY
- Replies: 4
- Views: 5117
- Wed Feb 12, 2014 12:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job got stuck when extracting data from SQL SERVER
- Replies: 6
- Views: 6452
- Tue Jan 21, 2014 1:24 am
- Forum: General
- Topic: How to login IIS webconsole V9.1?
- Replies: 4
- Views: 5645
- Tue Jan 14, 2014 7:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compilation error in transformer
- Replies: 8
- Views: 12926
- Fri Jan 03, 2014 7:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: New XML stage in datastage9.1
- Replies: 1
- Views: 1861
It is beautifully explained in the below pdf.
http://www.redbooks.ibm.com/redbooks/pdfs/sg247987.pdf
http://www.redbooks.ibm.com/redbooks/pdfs/sg247987.pdf
- Fri Jan 03, 2014 4:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Timestamp Conversion
- Replies: 10
- Views: 7814
- Fri Jan 03, 2014 4:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Timestamp Conversion
- Replies: 10
- Views: 7814
- Thu Nov 28, 2013 3:09 am
- Forum: General
- Topic: how many patches are released for 8.7 DataStage version
- Replies: 2
- Views: 2105
A quick google search fetched me the below link.
http://www-01.ibm.com/support/docview.w ... wg24032115
http://www-01.ibm.com/support/docview.w ... wg24032115
- Wed Nov 27, 2013 5:53 am
- Forum: General
- Topic: The IBM IOD presentations can be downloaded by anyone.
- Replies: 1
- Views: 2136
- Wed Nov 27, 2013 5:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer: No input sort key information found
- Replies: 2
- Views: 3393
- Mon Nov 25, 2013 7:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integer to Char conversion questions
- Replies: 12
- Views: 8721
- Mon Nov 25, 2013 6:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TimeStamp with Microsecond
- Replies: 6
- Views: 4128
You can try something like this :- Before populating the data into Teradata, use a case. Within the case , cast the said column into varchar and check for its last three substring values (and may be another cast is required to integer for comparison) if it's greater than 499. If it is greater than 4...
- Mon Nov 25, 2013 6:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integer to Char conversion questions
- Replies: 12
- Views: 8721
- Fri Nov 22, 2013 4:04 am
- Forum: General
- Topic: Passing parameter with spaces to Execute Command Stage
- Replies: 12
- Views: 7607