DSXchange

What a pity! You know, you might have aced that interview if only you were a subscriber to my blog! I seem to remember a post on that very topic. I did a blog on How do I get started with big expensive tools? about how difficult it is to get DataStage employment when you don't have experience with t...

You might find project specific environment variables easier to use then hash file variables. See my blog <a href=http://blogs.ittoolbox.com/bi/websphere/archives/datastage-tip-using-job-parameters-without-losing-your-mind-8587>DataStage tip: using job parameters without losing your mind</a> which h...

And since Microsoft is busy finishing Windows Vista there are not an infinite number of monkeys available.

94 is a great score, especially as there are a couple of questions that are almost impossible.

Also remember that you can use the invocation ID throughout your job as though it were a job parameter. You can put #DSJobInvocationID# (I hope that is the write name, typing it from memory) into job file name fields or SQL filter fields. This lets you choose a meaningful invocation ID that defines ...

You don't drink? Definitely can't be in an Australian user group!

Gartner ranked DataStage and Informatica as the clear leaders in the ETL field in last years ETL Magic Quadrant. Bloor Research ranked Informatica, DataStage and SAS in the top three in their latest research. It is very difficult to get an ETL tool comparison document, most of them are produced with...

You do not need to do any drastic when you move to Enterprise Edition, everything will keep working just fine. You can do an incremental conversion of some of your largest jobs over to parallel and leave the rest server jobs.

I have a blog and a magazine article about this topic:
http://blogs.ittoolbox.com/bi/websphere ... aires-9195

On my last project we took the approach of loading smaller volumes directly and staging the larger volumes to load ready parallel datasets. You might think that splitting a job into two (prepare and load) or three (prepare, insert and update) might result in more development time but it becomes easi...

On the [url=developernet.ascential.com]Ascential Developernet[/url] site is a recently uploaded file on configuring DB2 databases for Enterprise Editions. It goes into much more detail then the standard installation guide and is a must for what you are doing.

You can get DataStage Certification help at my new DataStage Squidoo site. It has a link to the syllabus as well as a link to my blogging on the exam.

Create parallel versions of each job you want to replace. Only replace your high volume and slow jobs, no reason to replace the smaller jobs. Use the copy parameters utility to copy the standard set of parameters into each of your parallel jobs. Give your jobs the same names as the server edition wi...

That's why it is being completely rewritten in the Hawk release to be a GUI tool on the DataStage Designer with patterns done in the client instead of notepad.

I am trying something new! You can also find certification links at my DataStage squidoo lens. There is a box there with steps for getting certified as well as links to various DataStage related blogs and information pages.

They do data warehouse appliances, so obviously a good match for DataStage. They list Ascential, Informatica and Sunopsis as partners. I think they have had a booth at a couple AscentialWorlds.

To run DB2 commands you need some DB2 environment settings such as DB2INSTANCE and the DB2 path. Your user id may already have these, try typing DB2 to see what happens. Your DB2 admin should be able to add those variables to your .profile file in your home directory. You also might be able to set t...