I written a PowerShell script to store the data as csv and used Datastage to load.
Thanks to all for your help and suggestions.
Search found 1213 matches
- Wed Jul 19, 2017 3:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading xls using Datastage
- Replies: 7
- Views: 5948
- Wed Jul 12, 2017 2:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading xls using Datastage
- Replies: 7
- Views: 5948
- Wed Jul 12, 2017 2:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading xls using Datastage
- Replies: 7
- Views: 5948
- Wed Jul 12, 2017 5:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading xls using Datastage
- Replies: 7
- Views: 5948
Reading xls using Datastage
Hi We have to start a new project to read the xls file and load the data into a sql server table . The challenges I have is 1. ETL need to read the data from 3,4,5...N sheets in a file . 2. in each sheet need to pull some specific range cell values, not the whole file ! 3. Other known issue we had w...
- Sun Jun 25, 2017 10:11 pm
- Forum: General
- Topic: Uninstall Qualitystage alone
- Replies: 0
- Views: 2801
- Thu Jun 22, 2017 3:17 pm
- Forum: General
- Topic: Disable Quality stage alone
- Replies: 2
- Views: 3159
- Mon Jun 19, 2017 2:34 am
- Forum: General
- Topic: Disable Quality stage alone
- Replies: 2
- Views: 3159
Disable Quality stage alone
Hi there I am in a situation to disable the Quality stage. I am using Datastage 8.7 in Windows. I can use LicensingServiceAdmin option which I have found in the IBM site. But I would like to know, is there any impact while Disable this? If anyone did this before, please guide me. Thanks in advance.
- Tue Apr 18, 2017 9:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read the space delimited file??
- Replies: 9
- Views: 8067
- Tue Apr 18, 2017 5:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read the space delimited file??
- Replies: 9
- Views: 8067
- Tue Apr 18, 2017 5:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read the space delimited file??
- Replies: 9
- Views: 8067
Re: How to read the space delimited file??
Yes that exactly i did after i post this query.chulett wrote:Or that string match followed by a substring. Once you find the position of an ...SURA wrote:I am thinking to use to string match and then find a way to load the data by using field function.
- Tue Apr 18, 2017 5:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read the space delimited file??
- Replies: 9
- Views: 8067
Rayray.wurlod wrote:Have you tried using a Sequential File stage with space (or 0x20) specified as the field delimiter character? If so, what was the result? ...
Yes i tried that option . The issue I have here is, a single file which contains 33 different events. Each events have different number of columns.
- Mon Apr 17, 2017 11:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read the space delimited file??
- Replies: 9
- Views: 8067
How to read the space delimited file??
Hi there I need some suggestions to read this file using datastage. This is a log file data which need to be loaded into a table. These all are the columns i am after: DATE TIME Event Username Application Created_By IP Details ClientId Log_Type see the below sample records from two different files, ...
- Wed Feb 01, 2017 8:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: UTC to AEST
- Replies: 8
- Views: 6753
Thanks Ray for cautioning. In this office somehow a manual process has been implemented as someone who physically update the reference table to get the offset. This table will always (I wish always) have the data for 2 years ahead. So it should be alright as far the data is being updated in time. To...
- Mon Jan 30, 2017 4:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: UTC to AEST
- Replies: 8
- Views: 6753
- Mon Jan 30, 2017 3:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: UTC to AEST
- Replies: 8
- Views: 6753