DSXchange

Hi Chulett/Andrw Thanks for the reply, Now i got how to proceed on this, but i am stuck in the execute command triggers to start or abort the job. If Trim(Execute_Command_22.$CommandOutput) = 'SUCCESS' Then Else I am unable to get which command to use to start the next job if the output is success a...

In my case, the job 1 will always be successfull. In the job1 i am writing a column into a dataset file i am fetching the column1 value from the oracle table. Column1 ====== Success or aborted. If the column1 value is "aborted" then the main sequence should abort. if the column1 value is &...

In my first job i have source as oracle table i need to execute a sql query to find out the value of the column in that table, that value will be success or aborted, if the value is aborted the next job should not start and if the value is success then the next job should be initiated. Regards, Aditya

Hi,

I have an requirement where in i need to run the job2 based on the output value of the column of the job1.

Job1 --> Job 2


Can anyone please help me on this.

The target is oracle table and the datatype is integer, so in the target i want the value to be 03

Hi, I have a source file which is fixed width and i am using substring function to fecth the value i.e testcolumn[25,2] and the value in source column (varchar) is '03' and the target is integer(2) field. In between, the source and target i am using a transfomer stage for transfomations on other col...

Thanks ray and ravi,

It worked.

Hi, I have a scenario where in there are 2 columns if both the columns have null values from the source then -2 should be harcoded and if any one of the column is null then the column should be rejected and if both the columns have values it should pass with the original values. for ex: Col1 Col2 Co...

User defined Block Size is 1

Hi All, This is Regarding the surrogate key generator stage we are using in the job. We are generating surrogate key with the state files concept We are running the job on 4 node, but when we run the job, the surrogate key values are been generated for two records randomly as below 3483 3484 when we...

I have a requirment where in i need to capture all the duplicates and null values into the reject table and into data error table Duplicate Check should be done on submarketcode,where all the duplicates should be captured for ex: 101 101 202 now both the records of 101 should be rejected and 202 sho...

TABLE1 -----------------------------------------------> JOIN 2 ---> FACT TABLE2 -----> COPY -- > AGG 1 ---- > JOIN 1 ------> JOIN2 --- > FACT -- > AGG 2 --- > JOIN 1 ---> JOIN2 ---> FACT -- > AGG 3 --- > JOIN 1 ---> JOIN2 --> FACT -- > LOOKUP_TABLE3 --- > AGG 4---> JOIN2 --> FACT -- > LOOKUP_TABLE4...

I am posting my job design below. [code] TABLE1 -----------------------------------------------------------> JOIN 2 ---> FACT TABLE2 -----> COPY -- > AGG 1 ---- > JOIN 1 --------------> JOIN2 --- > FACT TABLE2 -----> COPY -- > AGG 2 --- > JOIN 1 --------------> JOIN2 ---> FACT TABLE2 -----> COPY -- ...

You need to upload your screenshot to any of the free image hosting websites out there and then link to it from your post using the [img] or 'image' tags. Those sites will typically build them for you so that all you have to do is paste their completed tags into your post. Alternately, you can deta...

Thanks for your reply Venkat. How can find the MAX(REF_DT) before join?