DSXchange

ray.wurlod

mydsworld wrote:So, can I invoke the DS job for each of the param set value file like this below.

- param pS1 = pS1_VF1
- param pS1 = pS1_VF2
- param pS1 = pS1_VF3
so on

?

Only one values file name per dsjob command but, otherwise, yes.

ray.wurlod

ray.wurlod

Welcome aboard.

What have you tried? How successful was it?

ray.wurlod

1. You have to have the match frequencies. Whether you generate them for the reference data set immediately ahead of running the match or not depends on (a) whether the reference data set is fairly static and (b) your available time windows. 2. For two-source matches, yes. For one-source matches you...

ray.wurlod

Probably not. How do you feel about encapsulating a TRUNCATE TABLE statement in a Stored Procedure, which you could invoke from a Stored Procedure stage?

Of course, you could issue a TRUNCATE TABLE statement through sqlplus invoked from an Execute Command activity in a sequence.

ray.wurlod

A Search for DS_AUDIT may reveal what you require.

Default Engine credentials may thwart your efforts.

ray.wurlod

There's no big changes to the archtecture, except that you may choose to implement another database for the DataStage Operations Console.

ray.wurlod

If you want to choose a values file, name just the Parameter Set

Code: Select all

 -param pS1=VF2

If you need to override the default value of a specific parameter in the Parameter Set, use "dot notation".

Code: Select all

-param pS1.ControlFile=/data/Controls/weekend.ctl

ray.wurlod

Make this the first option within your CASE construct.

Code: Select all

Case Int = DSJE.BADHANDLE
   Job_Status = 'Error'
   Call DSLogWarn("Unable to attach job " : DQuote(JobName) : ".", RoutineName)

ray.wurlod

Just the empty database.

ray.wurlod

No more light required. Do the pivot as Craig suggested (using the Pivot stage), then you can do your individual lookups. Handle the failed lookups however you wish in the Transformer stage.

ray.wurlod

All projects, or just one project?

If just one project, consider re-indexing that project when you can get exclusive access to the project.

ray.wurlod

Try this (from page 25 of the manual):

Code: Select all

> | T
COPY [1](n)  {HouseNumber}
COPY [1](-c) {StreetName1}
COPY_A [2] {StreetType}

You may prefer to use intermediate variables, also discussed on page 25.

ray.wurlod

We're just ordinary posters. You need to email the membership director (see Contact link at top of page). While those who run DSXchange do visit here occasionally, they do check email far more regularly.

ray.wurlod

Not in version 7.x.

Search found 53125 matches