DSXchange

Ascential has started to include a detailed text document called dsbuildinfo.txt . On the CD it should be stored at the root directory. On NT server installs it is stored in the Ascential\DataStage\Engine directory. For Unix installs checkk dsebuildinfo.txt in the /Ascential/DataStage/DSEngine direc...

maybe the future will be better. I have heard of some proposed changes for ASCL's 8.X plaform that should reduce the performance issue mentioned here and well as increast DataStage and MetaStage integration. But 8.x could be a long way off still and don't want to post details of what I've heard for ...

still had troubles with Oracle's driver for RDB 6. When all else fails, go to HPUX. We're early in our project and will make use of RDB's utility to create flat file extracts as well as a 3rd party driver (Attunity) running on Unix. I think most DS developers prefer DataStage on Unix right? I tend t...

You're lucky you had only 3 columns to look at. I've had that error before with like 50 columns that were candidates. It always seemed like DS should be able to return which column the error occurs on. It seems like Ray sorted you out, but if you have many columns and aren't sure what data might be ...

It's probably considered a 'best practice' these days to make use of the Version Control client. Initialize components into the VC repository and then promote them to a production enviroment, ideally making them read-only and doing a mass compile at the same time. Otherwise, there is still the old s...

Can we assume then you are using the client switcher? I believe on 7.1 and prior this is an unsupported tool. Check readmes and ASCL to be sure. I also believe on 7.5 there is a supported program called Multi Client Manager. Version Control uses the client dlls and your issue could possibly stem fro...

I'm currently go through this configuration. With the Oracle RDB driver version 3.1.0 we can select data from RDB 6 (not sure if it is 6.0 or 6.1 or whatever), but we get an error in importing metadata :( I don't have the error message in front of me, but I think it was a 'metageta error' dealing wi...

Kim is right about the wisdom and experience part. But a certification would still be nice because its at least one step to identifying who knows their stuff on who is stretching the truth about their knowledge and experience. But you would still get intellectual types that could pass certification ...

Did anyone catch Ralph Kimball's presentation on June 3 on conforming your dimensions? It was hosted by some company called Informatica, I wonder who they are? Anyways, just curious if anyone else participated in the webinar. I'll try to post some thoughts from it too.

1) The trade-off is flexibility versus performance, and right now performance is a bigger driving sales factor than flexibility. 2) Personally, I LOVE the Server product and believe that Parallel technology should have blended into it for the E and L and some T. 3) Right now, my ETL solutions are m...

If you would like more information then please drop me a private line and I can send you some information on what we did and how we accomplished it. Mike, you want to delver deeper with Srinivas, but I'd still like to see a post here going a step deeper into the methodology you used. Or at least so...

I've got computers in which different information is presented in the Add or Remove Programs module of the Windows operating system. One install lists the installation size as the exact same amount of MB as the DataStage client. The other install lists it as the sum of the client and server installs...

Yet at the same time don't you feel quite powerful with it at your hands? That reminds me of a story of one of my companies favorite managers at a client. One of the IT managers was quite a character, and once said, "I love DataStage, I can write a DataStage program to wipe my ass!" You k...

If you're looking for a rules-driven transformation tool, it ain't DataStage . True. DataStage isn't strong in rules-driven transformation. Yet at the same time don't you feel quite powerful with it at your hands? It can certainly implement complex rules during transformation. Any thoughts on whete...

What is the purpose of SQL Server Enterprise Property Init.sql and when is it needed and when can it be omitted?