DSXchange

I am running the job through Job Activity which is set Invocation ID as Table Name and Triggering Expression Type as Unconditional . As Job Activity output link is given to End Loop Activity and this link has unconditional trigger type, I believe that the loop continues till all Invocation IDs witho...

Hi I have a Multiple Instance enabled job which runs for 60 tables. Table name is used as Invocation ID. I have created a sequence to form a loop which executes the job for all 60 Invocation IDs( Target table name). There is no dependency between one table load to any of other table load from these ...

Thanks Ray. It works... :D

Pons

Hi could anyone please help me out in listing parallel job that use Oracle Enterprise Stage in a project.? The actual requirement is to replace Oracle Enterprise Stage with Oracle Connector Stage in jobs. There are so many parallel jobs in the project. And more over we are not sure in how many jobs ...

If you come up with errors or warnings from the log of the job sequence, it will be helpful to resolve the issue..

--------
Pons

you can implement the logic using stage variables in Transformer stage

---------
Pons

you can implement the logic using stage variables in Transformer stage

---------
Pons

What is the extact command which you are using in your sequence to list the file?

--------
Pons

Check whether the following post will help you....

viewtopic.php?t=130623&highlight=sqlcode

The same kind of topic has already been discussed.
Please check whether the solution can help you to resolve your problem.

[url]viewtopic.php?t=125243&highlight=removing+header[/url]

--------
Pons

Use the below logics in stage variables sv_Opening_Bal ---> if @INROWNUM=1 Then 0 Else sv_Prev_Clsoing_Bal sv_Prev_Clsoing_Bal ---> closingbal in colunm deivation, assign the stage variable sv_Opening_Bal to openingbal column. date - date closingbal - closingbal openingbal - sv_Opening_Bal ---------...

If NAME does not vary across records for a single ID value, your approach should work fine..

But dont forget to set Ascending order sort for ID and NAME columns and Descending order sort for st_DATE column

There is option of limiting the number of rows to be processed at run time.
if it has been set, change it to no limit option.

Pons

Hi In a transformer, use the below expressions in stage variables svStartOfTheYear(Varchar(10)) = InputDate[1,4]:"-01-01" svNoOfDaysFromTheYear(Integer(3)) = InputDate[5,3]-1 And apply the following derivation in your output column. OutputDate = DateFromDaysSince(svNoOfDaysFromTheYear, svS...

The information that you have given is not clear and more specific to give a solution to question.