DSXchange

It is always good to use complete word instead of using short form. In datastage you have option to demote the fatal/warning messages into inforation log message. this option called message handler. you can write the message handler manually or can use datastage director to create it and add the per...

Could you please also add the fatal error message in your post

Hi All, I need your help to get the job elapsed time for al datastage job in a project. i am able to get the elapsed time for a job by using dsjob -report projectname jobname command. but it can give only for one job, please write me if it is possible to get the elapsed time for all datastage jobs b...

Suresh,

you can use oracle sequence and use a lookup stage in your job perform sparse lookup on oracle sequence and get the next value each time for each record.

i have a question, why can't you use KeyChange=1 in transformer instead of using stage variable. is there any problem.

my target stage is is sequential stage and am wrting records into delimited flat file

do we have any other way to do that without defaulting to any value for null

Hi vintipa ,

provide the correct databse schema name before the table name. and see weather you are running the oracle load in same schema or not

regards,

Hi I want to know what value we should use if we need to handle null for decimal and date fields and provide some value if thouse contains null value in souce fields. Please provide some suggestion if some one have already handled decimal and date field without using any type conversion functions. R...

Hello Vintipa,

In oracle enterprise stage we have options call Open Command and Close Command in stage propertise tab.

in your case you can use Closed Command options and can write the use defined sql query to update the table based on required condition.

my source is oracle table , in oracle stage you cant change any setting for a field

i am getting this message in transformer stage, i am not using any intermediate stages. or derivation.

i have one question. if a source filed is null and direct mapped to target field witout any trasformaiton, why we need to do any null handling.\

Thanks

prasanna i have also used the nulll to empty in target field derivation, but it didn't work.

Thanks

hello MDBatra,

can you please tell how to do this setting source side.

i didn't find any option to set in source side.

Thanks

Deepak[/quote]

Hi All, I have use the dsxchange search, i found so many way to deal with this situation, but not able to resolve my issue. I am getting the below warning messages in DS log. Xfm_Validation,0: Field 'Emp_code' from input dataset '0' is NULL. Record dropped. I am reading the field 'Emp_code' [Varchar...