DSXchange

From DS Manager focus on the name of the definition, right click the name of the table definition and rename.

What does automate mean? Scheduler? Coordinated jobs in a jobstream?

1. Not really, it still has to use 32-bit OCI for Oracle. 2. If you have to save persistent hash files and do a fresh project installation, I suggest you output your hash files to sequential files and reload the hash files after the switchover. 3. None. 4. Use the tool on the CD for mass converting ...

chulett wrote:when someone says they 'need a conditional lookup'... they really don't.

Yup, I agree.

Here's a DSX-Cutter you can use, export the whole project and then fire this script at the .dsx file. It explodes every object into a stand-alone file. You're free to expand the functionality however you like.

http://www.dsxchange.com/viewtopic.php?t=85518&start=0

The original subject, "Condition lookup", means that the second lookup is only attempted should the first lookup meet a condition. All lookups in a single tranformer are always attempted. Constraints have no impact whether a reference SQL is fired or a hash reference read is made. The only method to...

Read the 7.5 manual on restartable Sequences and how to configure. There's some specific ways to make it work, you need to understand it fully and the manual spends the time discussing it.

Your query is written such that the routine must only return one date value. If this is the case, use job control to fetch the appropriate value and pass it as a job parameter when running the job. Your query just uses a job parameter for the date. There is no method for doing what you originally re...

Search the forum for "SCD", this has been talked about a lot. You're talking about a type-2. The basic summary is: 1. Derive source row 2. Lookup using natural key against the warehouse for the surrogate key that has the max begin timestamp (or even better, and end timestamp forecast into the future...

Collect link statistics after every job run and store in a relational database. After every run, have a script verify the most recent run statistics for meaningful link counts against its average and notify if a X% drop occurred.

Somehow the file became corrupted. This is a runtime file, so you're able to fix it easily. First, using Director, try to clear status file, which may fix this file as well. If this doesn't fix the issue, export the job and re-import it. That recreates all runtime files under a newly assigned job nu...

can we run jobs on unix mechime which are developed on windows, if possible how? if not, how to convert those jobs to run on unix mechine. The first part of a two part question: If you developed on Windoze, make sure you choose Unix files whenever using the sequential file stage. When doing before/...

There are no conditional lookups. You could consider using transformers with link collectors to simulate a conditional lookup effect. Do the first lookup, and based on the result send to two different output links. The first output link acts as if the lookup was found, the second is the lookup not f...

No, isql and osql are Windoze only. They come standard with the installation on the server. You need to be able to run Windoze server commands from the unix box. The typical tools for this are rsh and remsh. It's kind of a security hassle to get a company to agree to enabling a user idea to execute ...

It seems any answer I will give will sound like it's coming from my "high horse". I would point out that the foreign key substitution of dates for their time dimension surrogate key is done at the EDW/CDW level, per Kimball, Inmon, etc. By all definitions that I know, surrogate key assignment and su...