DSXchange

No its not loading any data into the table .The volume that its processing is nearly 1 million.

I have a job which will do the updates to a database table .The job design is as follows : Sequential file -------> oracle enterprise ( update only mode ) . Please check the log below Occurred: 3:25:11 PM On date: 5/4/2010 Type: Control Event: Starting Job jobname. (...) Occurred: 3:25:12 PM On date...

Thanks craig . Seeing all the posts related to " rule engine " , It looks like its not that simple to implement .I am still unable to figure it out which technology will be a good option to implement the same . I am sure this type of requirement must have been done before . Any suggestions...

One of my friend suggested that this will be possible through OSH . I dont have any idea about OSH .

All the incoming records needs to be validated against set of rules that are present in a table .
Can someone tell if its possible through OSH ?

Hi Craig ,

Thanks for the direction .I have seen all the posts related to "rule engine "

But i feel its not a complex requirement .Just that transformations are dynamic . Cant it be acheived in a ETL tool like datastage ?

Hi Everyone , I have the following requirement : There are some 100 columns and i need to do some transformations on these columns . col1 , col2 , col3 , col4 ...col100 are columns . The type of transformations are stored in a table called rule_table .This table will be populated daily . Suppose rec...

http://www.odinjobs.com/Datastage_job_m ... rview.html

http://www.itjobswatch.co.uk/jobs/uk/datastage.do

Thanks a lot craig for your reply .

If logs are present in database then what about RT_LOGnnn files ?

I am still waiting for the log .Its been 3 hours

My bad ...I am till now using "Orchestrate Schema Definitions" for database...i am not aware that i can do for schema file ....Thanks alot

Hi ALL ,

Is there any way to get table definition fro schemafiles ? I have all the schema files and i want to import these schema files as table definitions . Any idea ?

Thanks all

Search for APT_STRING_PADCHAR

To conditionally abort the job use transformer stage

Hi Keshav , Thanks for detailed explaination .You have mentioned " If APT_ORACLE_LOAD_OPTIONS is used to set PARALLEL to FALSE, then you must set the execution mode of the stage to run sequentially on the Advanced tab of the Stage page " Could anybody help me in clarifying the below questi...

Just i am going though some posts and found that those questions regarding how to delete the filesets has not been answered .So , Out of curiosity i once again bumped that old post .

Any anybody help me answering above questions ??