DSXchange

hi all, The changes in the job design are not reflected in th esubsequent runs. To solve this I used the force compilation ,in that I am getting the following error Errorcalling Subroutine DSR_JOB(Action = 5); Check wether Datastage setup is correctly in project (Subroutine failed to compile success...

ArndW wrote:balu124 - you need to use DSLink17.Call_date[4,3] ...

Hi Arndw,
I used the same DSLink17.Call_date[4,3] ,I am getting DSL as output.

Maveric wrote:Copy Paste your exact derivation here. You can use the field() function. Field(input Date field name,"-" ,2) will give you "sep" as the output.

Hi Maveric
May I know where the field function available ( I mean under date functions or string functions....)

In a transform stage you can use the derivation "In.DateColumn[4,3]" to get "sep" from "29-sep-07" ... Hi Arndw, I used the derivation as "DSLink17.CALL_DATE(4,3)" I got the output as DSL. (DSLink is the name of the input link and the call_date is the name of...

Hi ,
I need to describe the day(sunday ,monday.....) from given date ,how to achive this one

any one please suggests?

Hi ,

I am getting the data from sequential file,in that the data for the date column is in the format of dd-mon-yyyy(Ex 29-sep-07).

I need to extract month number and month name from it .
fro extracting date and year I useed left() ,Right() . How to get the substring of thedate field.

Hi , When I did the changes in the transformer (hard coaded values) and run the job ,the changes are not reflected .I am getting the result using the previous mentioned values . How to overcome this and one more thing is cleanup resources option in the job tab of director is in desabled mode . Is th...

Hi , We need to genatrate a sequence number ,for that we used the sourogate key genarator. it works fine for initial load . My requirement is the sequence number has to be continue (starting from higiest value+1 ) in the next runs. for the I wish to take a lookup of target table on which the data is...

[quote="ArndW"]Yes. What is your target? are the two flows in the same job? ...[/ hi Arndw, Target is a dimention table in oracle database,thedata is loaded into target from one source table and a sequential file .Each output stream has it 's own calculations(different). There is no link o...

Hi , can we have a job design which contain multiple flows disigned separatly (no link between the flows) writing data into a single target . We take different instances for the same target (one target instance for one flow) and specify the orderof loading data to target ,is there any option as targ...

Hi , can we have a job design which contain multiple flows disigned separatly (no link between the flows) writing data into a single target . We take different instances for the same target (one target instance for one flow) and specify the orderof loading data to target ,is there any option as targ...

ray.wurlod wrote:One way is to change your expectations.

Hi ray,
I didn't get your words,could you please explain me in detail?

You could try importing the table definition using the Import "Orchestrate Schema Definition" instead of the Plug-in importer. It might give you more accurate metadata for a parallel job. It's a bit ... Hi vmcburney, Could you please explain me the steps in importing the oracle tables usi...

Maveric wrote:Did you try running the job by changing the data types to integer and date respectively?

Hi Maveric,
when we change the target metadata and run the job we got the errors like this numaric value ou of range even we define the metadata correctly

Maveric wrote:Did you try running the job by changing the data types to integer and date respectively?

Hi Maveric,
when we change the target metadata and run the job we got the errors like this numaric value ou of range