DSXchange

Great thread Sean, thanks for sharing your experiences and providing the resolution.

Izack wrote:

swades wrote:I am help less............Thanks for your help

Quote of the day.

There is a manual in the Information Server documentation called Parallel Engine Message Reference that describes errors with explanations and solutions. Looks like they haven't put it online.

ETLStats has the SQL in it you can use to get to the process metadata. It also has a couple of jobs you can use to run the SQL and extract the results to a file or table.

I only ever use the Change Data Capture stage and ignore the other two stages. I think the CDC stage was developed as an improvement to the Difference stage though I don't know where I originally read this.

All th eDataStage 8 documents are at the Product documentation ibm website including tutorials for DataStage parallel jobs and QualityStage version 8. There is not a huge difference between DataStage 7 and 8. You might be able to navigate the ibm website to find the version 7 manuals.

I've been trying to do the same thing with the CFF stage and if you don't have a cobol definition file it is difficult. The direct data entry of metadata into the CFF stage seems to be almost impossible, I keep getting errors on level numbers. It may be easier to try Arnd's approach of dummying up a...

DataStage 8 comes with the following access via the SAP Packs (at an additional cost): SAP BW Pack BAPI: (Staging Business API) loads from any source to BW. OpenHub: extract data from BW. SAP R/3 Pack ABAP: (Advanced Business Application Processing) eliminates manual coding and provides change data ...

Version Control has been dumped from DataStage 8 however the import/export functions have been improved and are in some ways better than the old VC functions. It is easier to build, add to, search, filter or view an export file under DataStage 8. So you could build release files under version 8 and ...

The bulk load stage may give you what you want. Hard to do with upsert/insert/update type loads because you need to do it all in one very big transaction. Not really scalable.

It may be possible to export an ErWin model as XML and import that into MetaStage. A colleague almost got this working but there was one data type in the XML file that MetaStage couldn't handle. He thought you might be able to make an minor adjustment to the XML through Perl to get it into MetaStage.

It gets a bit ugly when you try and do it in a parallel job. A lookup stage would allow multiple lookups to be returned and give you every possible combination for that key. A filter stage would remove all the rows where the lookup date was too high. A sort or remove duplicates row sorted by date re...

I would first try to build it using a lookup table, though this depends on whether the equation fits a lookup table design. Second I would try stage variable code which works well for up to three lines of code per stage variable but is stretched beyond that. Third is probably external routine so you...

I'm not sure what install you are running or whether you did the first step of the install wizard incorrectly. When I run the Info Server install.exe I get a wizard where the first form is a warning about disabling the firewall and the second form labeled "IBM Information Server Layers" has check bo...

I would be surprised if anything in an ETL tool could match the performance and efficiency of a native Sybase replication tool for the straight replication of data. ETL really comes into its own when you are using the "T" in ETL. If you are doing straight CDC with no transformation/consolidation/cle...

Some sorting and aggregation may go into your temp directory. Most datasets will be saved onto your node directories as defined in your configuration file. Your machine may have a lot of disk space but you need to make sure it is allocated correctly. Disk space monitoring during a test run will tell...