DSXchange

Smitha, Can you see any data when you do a view data on the source Dataset?? Can you see any data passing through your job using the 'show performance statistics' option on the Designer Canvas?? Do you have your 'Rows to Display 'set to a number greater than 0 and your 'Skip Count' set to 0 when you...

You can use a user-defined update statement in your OCI Stage

Update <Table>
Set <CountField> = <CountField> + 1
Where ....

You need to 'hard-code' the spaces between your parameter values

e.g. #username#:' ':#password#

Did you monitor the job while it was running?

How many rows went between the CFF and Transformer and how many between the Transformer and the Oracle Stage??

Is someone else inserting rows into that same table??

The quickest way is probably to use a hashed file. Create 2 columns. Hard-code the first column with a value such as 'X' and make this the key column in your hashed file. Set the derivation for the other column in your transformer to @OUTROWNUM. As the rows pass through the hashed file they will be ...

I suggest you have a look at the Datastage CRC32 function. You can use this to determine whether anything has changed on the record since your last extract. What you are trying to do it a standard Datawarehousing requirement and I am sure a search of this forum would return lots of helpful informati...

Sorry Ray...I would have to disagree with you on that one...

It is valid to have a single input and single output from a Filter stage.

Hi,

My guess is that you have made a mistake in defining the output link that your where clause is associated with.

If you have a single output link then this value should be set to 0.

If you set it to 1 then you will get the error that you are reporting...

Hope this helps.

Hi,

Create 3 Stage Variables with Integer Datatype and convert your eff_dt, term_dt and last_dt into Julian Days using the JulianDayFromDate conversion function. Store the values in the 3 stage variables.

Use the Stage Variables in your constraint.

You need two links coming out of your nested condition. Choose "Custom - Conditional" for the Expression Type and use the following code in the Expression fields oconv(Date(),"DWA")="SATURDAY" --Link goes to JobS oconv(Date(),"DWA")="WEDNESDAY" --Lin...

What is your target?

Database, Dataset, Sequential File...??

What is the datatype of the TRADE_DESK_AUTH_PRICE_PCT field?

Hi Andal,

As far as I know there is no way to export job executables from the command line...

Thats not to say it cant be done

In the job properties of the Job Sequence there is an option to 'Add checkpoints so sequence is restartable on failure'

This should work as long as you dont reset the job before re-running it after an abort.

Hi Andal,

What exactly are you trying to achieve??

You can export datastage jobs via the Datastage Manager. Here you have the option to include job executables in your export.

Just have lookups to both hash files from your single transformer.

Then in the derivation of the output link use the following kind of logic:

If Not(IsNull(Hash1_Lkp)) Then Hash1_lkp Else If Not(IsNull(Hash2_Lkp)) Then Hash2_lkp Else 'Not Found'