DSXchange

logic

hi hemant, Sequencer?Sequence?other activity? Please describe more clearly. when both the dimensions sequencers are completed then only my fact sequencer should run As ucf007 sugessted just link your 2 job activities for dimension seq's to a sequencer and set mode to all. Output to the job activity ...

logic

Code: Select all

Any Suggestions (other than installation of patch; bcos it will take about 1 month for approvals to come thru) to resolve this issue

I was thinking If Performance is a second priority , did you try using other stage than OCI?
ash.

logic

Hi Nagesh,
Some thoughts.
If you are using a userdefined sql, then first try checking the sql. Also check for other clauses like Where etc if you are using any. If you have a generated sql and if any of the columns is a CLOB,then that might be part of the issue.
Ash.

logic

Yes Craig,
I am trying to select CLOB and insert into a table. It is true that I am having problems Because data being greater than 4K.
Thanks.

logic

Hi Craig, Any developments on The CLOB issue. If so PLEASe update. I am facing similar situation and tried all the above solutions but nothing seems to be working. Stopped thinking Logically and tried the trial and error path. :( We were initially using a DRS stage. Then we switched to OCI. When we ...

logic

Hi, This error is ocurring due to a CLOB column. Previously This problem was solved when I removed the CLOB column. Now I have to incorporate that column. I am using DRS to extract and also to write the data. I defined the column as varchar 4000. But Rows are getting rejected with the error "In...

logic

Also It would be good if a option to "insert all parameters",(Something similar to match columns in the transformer),can be added to the External parameter helper window. It would help in selecting all values, instead of selecting one by one, while inserting parameters in a job activity wi...

logic

what exactly do you mean by "sequencer Fails"..

. If you want to say that the first job fails/first sequence fails and still the next job continues then you should check the trigger.
Hope this helps,
ash.

logic

It would not matter if the table is accessed by multiple user at the same time for reading data. The warning: Could not position within a table And for the error you have stated pls search the forum refer to the suggestion by Ray http://www.dsxchange.com/viewtopic.php?t=95336&highlight=position+...

logic

Hi Naga, One way to stop the sequnce would be from the director. You can stop the top level master sequence which in turn will stop the sequences within. After stopping the request would be sent to the server so will have a time lag before the sequnce stops. You can stop the sequence by "kill&q...

logic

SEARCH@FORUM HELP@MANUAL

for example:

viewtopic.php?t=93850[/url]

logic

Use ":" if doing in trans else use"||"
Try the following

Code: Select all

SELECT (t.area_code || t.prefix || t.number)  as ph_nbr  FROM abc t

cheers,
ash.

logic

IF THEN ELSE.........

logic

Thanks Ray..........I had tried searching but dint use SIGSEV rather used signal_handler instead to search..

.now I got it...Thanks

logic

Hi, I am trying to track changes using the change compare stage. Using the DRS stage to read the "before" and "after" Table and writting the records to .fs I am seeing few warnings and errors which i am not sure how to solve. The warning is. After,0: signalHandler__Fi() at 0x204f...

DSXchange

Search found 115 matches

Sequence parameters

Error while using Change capture stage