DSXchange

I've never found UNIX drivers for Microsoft Excel or Access. I have however heard of accessing Access dbs on UNIX by going through the MySql database because it can get to a Windows Access db through ODBC. This link might provide a little more insight:

http://www.myfirsthosting.com/ms_access.htm

I have an anonymous wp that discusses when to use multidimenional or relational OLAP. This is probably a different slant than the original normalized vs. denormalized question, but thought it may be useful or could make the discussion more dynamic. Here is a paraphrase of when it says a multidimensi...

There are a few new stages. A command stage that allows an OS or UV command to be run and can write to an output file. A Link Partitioner stage that is an active stage which takes one input and allows you to distribute partitioned rows to up to 64 output links. A Link Collector stage that is an acti...

To read Excel from DataStage NT simply create an ODBC dsn to the file (tables will show up as system tables when importing metadata). Easy. Now onto reading a spreasheet from a UNIX DataStage server: Ideally, an ODBC dsn on the UNIX side would work, but is this even possible? If you know how to crea...

That's the typical unmeaningful error message to expect from the OLE/DB stage. Sometimes there are multiple providers that can be used (if connecting to SQL server there is a SQL server provider, an ODBC provider, and a simple provider that can be used) that sometimes yield different or better error...

For some detailed info on hashed files go to http://www.fitzlong.com and click on support and technical papers. You'll find some white papers from the early 90s (but still valid) pertaining to hashed files. It is geared towards the UniVerse user and is probably more info than a DS developer needs to...

I'm wondering if maybe it's just an illusion that the query is taking that long but instead the job is performing another task before starting the query. One thing to check is if the job has another database stage that it's writing to and the update action is doing a clear of the table first. DataSt...

There actually is a handy search tool, it's just easy to overlook. Underneath the Tools4DataStage heading on the top right there is a group of hyperlinks. In between Members and FAQ is Search, and this function lets you search for exact key word matches, any word matches, limit the search to a date ...

It's Friday afternoon, 5 minutes before 5PM....so I'm sitting here compiling my Version Control project with CompileAll and timing it. On a slow client and slow server I still was able to compile 243 jobs in 2:40. Additionally, those of you wanting to speed up compiling with this tool or just when d...

I have some jobs that are reading an UniVerse tables with multivalued columns and load to SQL Server after the transformer breaks out multivalues into multiple columns. Displayed by the performance when having the ODBC stage set to 'Insert new or update existing' I changed it to 'Clear the table bef...