DSXchange

Fabs !! Thanks for that dsdesigner, had exactly the same issue, and Fabs worked perfectly !

Hi. I'm trying to replicate the various datasets that exist for my datastage solution to help with testing. My approach is to create a sequence, which loops through either a table of dataset filenames, or perhaps just reads through the entire directory of dataset header files, and populates a parame...

It stands alone, there is no sequence in the database.

Thanks chulett. I couldn't really get good information on updating the surrogate key state files. I am slightly confused as to how they work. They are currently have option "Generate Key from Last Highest Value" set to 'N'. When I did some testing I found that set like that, even when I up...

Hi, Can any one help me in sorting out the below issues? a) how to remove space inbetween the characters that comes from XML stage? b) how to send the XML records to the webservice stage? Process: 1) Reading two tables and joining using the join stage based on key column and it is a left outerjoin. ...

I am devising a method of refreshing the development DW environment from production. There are the database elements, which I'm on top of. I have a couple of questions about a number of DataStage concepts which I am looking for help on. i) I've created a job whereby I"m updating the surrogate k...

I'm trying to get the bulk load functionality going inside of the Dynamic RDBMS stage to load +-45 million records into SQL Server 2008 (source is a SQL Server 2005 table). The ODBC connection I'm doing this through has been configured correctly and if I set the Update action to 'Truncate table then...

I got this resolved by a controlled restart of the Services and Engine tier servers.

Have you/do you have access to any data profiling tools, such as Information Server Information Analyzer or InfoSphere Discovery (there are also a whole host of non ibm and open source options). These sorts of tools should be used during the onboarding/analysis of new data sources to identify the un...

I noticed that too, I thought/hoped it was a bug. I've got a feeling that in cases where the author and publisher are different that the 'original' author is not recorded in the published glossary either, rather the creator and modifier are recorded as the publisher.

Yes, as far as I know I just need to set the User, Password, HostNameForAuthentication and PortNumber which I've done.

I'm trying to import the operational metadata into the repository to view in Workbench. There are generated OMD xml files ready to be imported and I've configured the runimport.cfg file accordingly. But if I try to execute the RunImportStart.bat file I get the following error: ... a whole lot of pat...

What is the correct syntax to import Fasttrack assets into a different Fasttrack project? According to IBM documentation and tech notes on this topic, they indicate that the following syntax for the import process needs to be used: import -u admin -p admin100 -dom EVEREST -ar ft_archive1.isx -fasttr...

Our production sequence job starts failing a few days ago on the notify success activity, getting the following error: JobControl (DSSendMail): Error when executing command: C:\IBM\InformationServer\Server\Projects\sendmail_s_load_main_84225217_3112.bat *** Output from command was: *** SMTPMail Look...

Is there a way to dynamically pass a field value to a parameter which will be used to generate an XML file name? For example, I need to process thousands of policies, with policy number as the key identifier, and generate a xml file for each policy. The requirement is for the XML file name to contai...