DSXchange

Hi Team, We are working with tableau which access TDE extract files as source to generate the reports. TDE extract file is generated by joining two are more sources with in Tableau and reports use these generated TDE files as source and display results on dashboards. We would like to reduce load on ...

Hi All, We have created a batch script to list the available projects in the datastage environment. Command: dsjob -lprojects The command is working absolutely file in one of the development environment. The same is migrated to another server and the command aborted. Later did our analysis and found...

Thanks for reply, For writing a script, I got the answer as to use "istool". But I would more of like to know whether I can use IBM Information Server Management tool as a configuration management tool. If so, then do I need any third party tool like IBM Rational ClearCase etc., Thanks &am...

Hi chulett,

I am using Version 9.1.

Regards,
Sandeep.

Hi Chulett, Thanks for your response. Yes, I have tried the "istool" command line interface and the testing is successful. Andy had defined in very detail the use of command line interface. One more point is that as I go understood that "IBM Information Server Manager" is designe...

Hi All, I would like to know is there any process that helps to automate the process of taking backup's of the code in datastage and maintain versions. I started wring a batch script but my installation shows that that there is no command "dscmdexport" to take an export of the code. So I s...

Hi all,

The issues is resolved we have installed a new version of nzsetup including nzload utility.

The test is successful and the Netezza Enterprise stage is working as expected.

Thanks for all inputs.

Regards,
Sandeep.

Hi Ray, Yes, The metadata data is imported and never was edited and in such case job was errored out with error mentioned in "Scenario 1". Sa as in resolution process I started editing the metadata expecting to be issue but the job failed with error mentioned in "Scenario 2". I d...

Hi All, We are trying to load the netezza data base using Netezza Enterprise stage with load option defined as "nzload". The load failed due to multiple reasons and below mentioned are scenarios. Scenarion 1: The metadata in the Netezza Enterprize stage in Set to VARCHAR with UNICODE optio...

Hi All,

Thanks for all responses.

We just re-ran the job and is successful.

Thanks ArndW for your response and please find the below mentioned details as requested. Details : Job Start DateTime: 2013-05-27 4:53:24 AM Job End DateTime: 2013-05-30 5:14:39 AM (Warning Time) I checked the existence of target file in the target directory and is available, so I confirm you that t...

Hi All, I am executing a datastage parallel job with the below mentioned design. Design : ODBC --- SequentialFile. The job is designed to send JMS requests to the Queue and is a long running job which will run more than 2 days. After being executing for 5 days the job had aborted with the below ment...

Hi Ray,

Thanks for your prompt response.

The idea of reading through VARCHAR worked.

Regards,
Sandeep.

Hi Chulett, Thanks for your response. Yes i am getting a text file as a delimited separated ( Pipe Line : |) and format of records are as defined below. Ex : H|1|2|3|4|5 I|1|2|3|4|5|6|7|8 I|1|2|3|4|5|A|B|C H1|2|3|A|B I|1|2|3|4|5|A|B|D So I want to read the set of records which are as defined above i...

Hi,

Can we read a delimited separated file using CFF stage.

If YES please let me know how.

Thanks In Advance.

Regards,
Sandeep.