DSXchange

You need to either deduplicate your lookup stream by providing a better SQL select or pushing it through a remove duplicates stage or improve the lookup key fields to add an extra mapping field that will gaurantee your lookup is unique or review the lookup data to see if the source table has duplica...

On a parallel stage is there any chance the before-SQL and after-SQL could be executed on each node? This would result in duplicate drop and create commands.

Looks like it's trying to disable the constraint when the job starts, jam the data in there and enable it when the job finishes. Do you see any commands in the before-SQL and after-SQL tabs?

There were a LOT of sequencer job enhancements in 7.5. The two important improvements for you is BASIC-like expression syntax in most job sequence activities and the User Variable stage. Sequencer jobs in 7.1 do not have it and are not nearly as easy to use. You could try a basic routine that retrie...

This is from the old Orchestrate developer guide in the section on DB2 load options: -msgfile -msgfile msgFile db2load only. Specifies the file where the DB2 loader writes diagnostic messages. The msgFile can be an absolute path name or a relative path name. Regardless of the type of path name, the ...

A good evaluation Larry, SQL Server 2005 is a strong competitor to WebSphere DataStage and Oracle and Hyperian and Business Objects. I'm sure both Informatica and Ascential saw the writing on the wall with the SSIS development and aimed at richer ETL rather then cheaper ETL. The Hawk release has int...

You will be interested in the product that supercedes AuditStage, the Data Analyser will come out with the Hawk release this year and will combine the functionality of ProfileStage and AuditStage and share a repository and metadata directly with DataStage.

Two things to look at are row comparisons, where you compare the number of rows for each link of a DS4 job against the DS7.x jobs, this requires some extraction of the row counts. This can be done via dsjob reports or by ETLStats, though I don't know whether there is a version 4 compatible ETLStats....

Most people running parallel jobs on Windows are doing it for training, or evaluation or off-site development. Most parallel production systems are on Unix. It helps to define two nodes in your test/dev environment on Windows so your unit testing includes partition testing.

You should be able to use two functions together, however it is easier to test the syntax on each function seperately in a test job and then try putting them together.

I counted four pennies and it was a very useful answer. I especially like the part where you mentioned that I was right about something.

I've seen a lot of success with metaframe, the product effectively manages profiles and registry settings and gives very good performance. I haven't seen it attempted via terminal services. Does it handle multiple users on the one remote machine at the same time?

I don't think it can be done in a modify stage. You have just a very small number of string manipulation functions, basically you have string_trim and substring and that's it. Every other string function involves the lookup conversion or the type conversion. So your only shot is to split it into two...

It's one of those cases where an archive search may be misleading. Early threads on this topic will recommend batch control over sequence jobs due to missing sequence job functionality, through version 6.x and early 7.x you could do some work through sequence jobs, by 7.5 sequence jobs had most of t...

I am so glad they didn't have questions about this in the certification exam.