DSXchange

I written a PowerShell script to store the data as csv and used Datastage to load.

Thanks to all for your help and suggestions.

Thank you UCDI

chulett wrote:Oh, they are all possible but

Thank you so much for your reply.

Is that means in 8.7 we can do the range selection ?

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

Hello All

I managed to uninstall the QualityStage alone.

I will update the steps here. So that it can help others.

Thanks Ray.

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.

Yes , i am marking this thread as Workaround.

Thanks to all for your time and help.

The ideal "solution" is to push this back on whoever is responsible for . You are 100% right. The issue are... 1. When they gave the sample file, it wasn't that bad. Though the work is messy , still it was manageable. 2. When the scope was extended, then few new files came, then we starte...

chulett wrote:

SURA wrote:I am thinking to use to string match and then find a way to load the data by using field function.

Or that string match followed by a substring. Once you find the position of an ...

Yes that exactly i did after i post this query.

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

Ray

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.

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

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

It worked perfectly.

Thanks to all for your help.

Thanks chulett.

Yes it is.

I will check this.