DSXchange

You can use the Basic Transformer to make use of server transforms and routines in a parallel job until you migrate them eventually to parallel routines. You can find the BASIC transformer under Stage Types -> Parallel -> Processing

The list of compilers that are supported can be found on the IBM web site: http://www-01.ibm.com/support/docview.w ... eswwindows

You can download the Visual Studio express version from http://www.microsoft.com/exPress/

You can add the environment variable APT_STRING_PADCHAR with the ASCII value for null (0x00) to the job or set it in DataStage Administrator so that the loader will pad the string with null as opposed to space

Not a tutorial, but have a look at the IBM Redbook for IA and data quality assessment http://www.redbooks.ibm.com/abstracts/s ... .html?Open

We use the option "Export job designs without executables". All code goes through our source code control procedure. Code is promoted through each environment dev->test->prod. The source code is imported into each environment then compiled. Good source code control should minimize the chan...

The answer to your question can be found on the IBM web site: http://publib.boulder.ibm.com/infocente ... s_cpp.html

Just add an extra link coming out of the transformer stage, so that one link (the undistributed link) still goes to the Oracle stage and the new link goes to the peek stage. You can then just copy the columns and derivations onto the peek stage link. e.g. seq.File---->transformer------->oracle | | \...

What is an XL file? Do you mean Microsoft Excel?

See Carig's post in this threadviewtopic.php?t=126185

You could load your data into a another database table and then use some VBA code to pull the data into your Excel spreadsheet. You will need to have the database client and API software installed on your local PC. Once you have retrieved it you then can manipulate the data however you like in Excel...

You can compress data using the "compress" stage without having to land the dataset to disk then compress. I suggest that the original poster create a couple of sample jobs, one with the compress stage and one without. e.g. source stage -> compress stage -> dataset stage Run the job and fi...

The xml files in the directory IBM\InformationServer\ASBNode\conf\etc\XmlFiles are the operational metadata files. These can be imported into the metadata repository using the run import utility (RunImportStart.sh). This information can then be displayed in Metadata Workbench. Have a look in the doc...

Your transaction isolation should be in your source Db2 stage. Try setting it (if not set) to "Uncommitted Read"

What is your transaction isolation setting in the API stage? Can you post your SQL for both source and target stages as well?

Do you have a sample of the machine log that you can post: Mine looks like: <?xml version="1.0" encoding="UTF-8" ?> <machine_resource_output version="0.1" start_date="2009-03-31 18:10:12" framework_revision="IBM WebSphere DataStage Enterprise Edition 8.0....