DSXchange

Here is how we did a TIME_DIM. You could easily change the "MTHs" into "D4-" to do a DAY_DIM table. The concept is to do all this in job control and write to a sequencial file. * ================================================================= * Job: ExtractTimeDimStg * ============================...

I am sure some things will break in the next release. I am sure it should not take long to fix them. It takes me a few hours to get this working on UNIX. It takes me a few days to get the emails going to the right people. I still do not have it working on Windows though. Let you know when it does wo...

Expect more and more automated QA to be added to DwNav. I hate QA. Say it with me. "QA serks." Documentation too.

Tell them Ray man.

Please do not send me any more private emails about this. It is free. Post your questions in this forum and I will answer as soon as I can. Buy ParameterNavigator, DwNav or DsWebMon and I will answer your private emails. I do appreciate the compliments though. Makes my day when someone says thanks. ...

There are a couple things I just hate, documentation and QA. So I have tried to automate both. My attempts at automating documentation include EtlStats, GenHtml, DwNav and a few more. DwNav is a product I sell on my web site. The others are free to download on my web site. Part of EtlStats has an au...

Rough day, Ray?

You also cannot execute this in the bin directory. Add the bin directory to your PATH. Execute this command in a project directory.

Scope is the difference as well as formulas. A stage variable is only valid in one stage. It can have a formula based on routines or anything you can do in a normal derivation. A parameter has one value for the duration of a job. It is set when you start a job. It is normally used for things like se...

Do a search this has been covered. There was even articles in the newsletter on www.tools4datastage.com.

I think this is one of two things. Either a section is missing or you defined 2 groups which repeat. I had to process the same data twice because or 2 groups which repeat.

You need to call support.

The only errors we have seen with VC is when you try to use VC and someone has the job in question pulled up in Designer.

SETFILE is Ray's way of creating q-pointers. The ED editor is my way. I just showed you in the above post. You have to edit the VOC file. You need to learn more about Universe to do these types of things. Not hard at all.

Either but I was thinking job. The problem is that the format is not like a program where you can easily merge lines. DSX files have a strange format.

No way. Lets say you add 2 columns. Someone else else a third column. I doubt if any product can merge these properly.

There are some tricks you have to do to SELECT either DS_JOBS or DS_JOBOBJECTS. IBM tries to protect these files. You cannot import metadata from them directly. I usually create a q-pointer which is like a synonym. ED VOC DsJobs 1:Q 2: 3:DS_JOBS ED VOC DsJobObjects 1:Q 2: 3:DS_JOBOBJECTS Now you can...