DSXchange

Thanks to all of you for the feedbacks.

@ Craig: I'll try and write a custom trigger expression and see if that works.
Will keep you'all posted on my findings.....



Regards,
Kumarjit.

Thanks to Craig for giving me a direction to walk towards. And pardon me for the usage of inappropriate English as in "manipulate", because all I wanted to know is that if there's any way that I can skip/not let a constituent activity in a job sequencer to get executed on a specific day/ti...

Thank Heavens that I finally get to have the MASTER of the Business reply on my post... :) But Ray, "No" as in? Do you mean to say that if there are three activities in a sequencer, and if I require to configure the second activity not to run on the last day of every month , I wont be able...

Is there any way that I can manipulate the individual activities in a job sequencer to execute at different intervals?

Please help.
And if there's any further information required,do revert.


Regards,
Kumarjit.

Close????? Its more than close eh!!....
Thanks to all of you for your support.

Regards.

stuartjvnorton wrote:Read -> Agg (mean value) -> Filter -> Done ?

Didn't understand how could you achieve this using a single read?
Please explain..

Regards,
Kumarjit.

However, in my opionion there's nothing wrong with how you've done it... I assume it is working for you, yes? Yes it does Craig.... :D What I'm seeking for is an alternative approach, where I'll be using a single Oracle Connector to fetch data from the table once and for all, and then use them to f...

Hello all. Pleasure writing back in this forum after a pretty long time. At the outset, I'd like to surrender that I tried to search through all the post, but somehow did not get any relevant posts, but if there are any, please let me know of it. I'm trying to retrieve records from a table called EM...

StringToTimeStamp works good only if the DELIMETER in the date field is "-" (as set at Project level) and not "/" (as is in my case).
And yes , the 12 hour format (AM/PM) is required (that is the core of this requirement).


Regards
Kumarjit.

I have a requirement , something like this : In our parallel job, we need to read a source file , one of the fields of which contain data like : 08/24/2012 23:11:15 What we intend is to transform it to a format like : 2012-08-24 11:11:15 PM I was looking ahead to use the OCONV function(as because I ...

Anyways , thanks for your time people....

Regards
Kumarjit.

@craig : As I mentioned in the job design , there are three parallel data flows , each of which ending in an OCI stage , the surprise is that the same block is not getting executed (or skipped as I had been saying all this long) if used as a post sql for the second OCI , but when invoked from the fi...

@craig : Sure , its something like the one below : BEGIN BEGIN /*Script for creating index on a table whose name is a Job-level parameter*/ END ; /*Script to Update the table based on a specific criteria*/ END ; Surprisingly, this code seems to be doing fine when run from a sql client tool like SQL ...

Hi there , Been a long time since I'd posted last in this forum. Hope you all are doing well . I came with a pretty odd hitch that we faced in one of our parallel jobs. But the real trouble is, the same design is used in multiple other jobs as well, hence an error here would mean that changes are re...

I'm employing a lookup stage to refer my main source with TWO reference links , one of which would be set to return multiple rows if the lookup is successful. Following are the schema of Stream link, and the Reference links MEMBER(stream) will have fields MEMBER_ID, FIRST_NAME, LAST_NAME , DOB ADDRE...