DSXchange

Hi,

If "rows per transaction" is set to 0 in OCI stage then will all rows get same timestamp if I hace update_date_time column in the target table. Please let me know.

Thanks

Hi,

Does exception handler terminate job properly with out any phantom error.

Thanks

Hi, I need help with xml output file. Input: Has 3 columns. First two columns are same. The third column has distinct values. a 1 aaa a 1 bbb a 1 ccc Output: A xml file with first two columns in one tag each and the the third input column values in distinct tags as many there are. In other words if ...

Thank you all for clarifying.

Hi,

Do you know what is the relationship/formula between number of nodes that can be used in a project and actual number of nodes available on the machine in parallel edition of datastage?

Thanks

Source is sybase. Target is oracle.

data in all other tools also are null.

Hi, I have to to delta inserts/updates/deletes from sybase to oracle datamart. We have used change capture feature on source side that comes with parallel edition. We compare sybase date columns with oracle date columns metadata being the same. These date comparions are not working. We have data in ...

Thanks Ray. You are right that was not my problem.

I have a parameter of length 357 & I thought 255.

Hi,

Can you pls let me know what is the max string length in parallel edition.

Thanks

Thanks Chulett & Ray.

I will be more specific in future.

Hi,

I have a general question regarding a job. I have been working as ETL developer extracting data from db using datasatge. How difficult will it be to swith over to loading data into db.

Thanks

I did use start loop/end loop stages. Also wrote a routine in datastage manager to get days in previous month. _____________________________________________________________ * The routine gives the number of days in previous month and previous month's year & month. * Ans=0 ArgOut=0 TODAY = OCONV(...

Thanks all, I will give it a try.

Can you please give what stages