DSXchange

Hi,

My source is having one of the 'Date Field' as an integer type , and i want this to be converted as Date type in the target.

eg: the source contains

20080325 i want this to be stored as date format in the target, can any one help out in this?

Regards,
Senthil MP

Thansk it works

No i dont have indexcon the key column, do you suggest to create one?

Hi, One of our job is processing only 5 rows per second, we have nearly 0.23 million source records and the update rule in the target is 'update existing rows only'.Can anyone pls help me out how to improve the performance of this jobs. i have disabled the index and constraints on the target table, ...

Hi,

Currently our datastage is setup such the a job fails on 50 warnings,
now i want to make only a set jobs not to fail upon warning.

Can you pls let me know how to set these setting for a particular set of jobs and not for the entire sets.

Thanks,
Senthil MP

ray.wurlod wrote:Create a routine or command to read the log entry in question and write it to your file. ...

Hi Ray,

thanks for the info, but can u still help me how to achieve this, am really not aware hw to achieve this.

Pls help me out

Thanks

if its doing update and insert mean it will take more time to process, Oracle bulk load doesnt support this.

I think you can use ORACEL BULK LOAD stage, this will give you enormous amount of performance tuning

Hi, How can i write the error we are getting in the director log into a file or table, eg: am having a job which reads from source and inserts into a table, when some oracle error like (datatype invalid or inserted record too large) happens i want this particular error message to be captured in a fi...

Pls try out by changing different NLS setting, atleast one will support the character

Hi, I am capturing the reject records in a file by using OUTPUTLINK.REJECTED, now what am trying to do is when the file (which holds rejected record) is not empty then a notification mail should be sent. and if the file in empty then the notification mail should nt be sent. Pls help me out in doing ...

What "date format" do you need? There's always an IConv/OConv pair but if your incoming format is consistent then substring should be fine. For example: YourField[1,4]:"-&quo ...[/quote] I need DD-MON-YYYY format ie (I am creating table through Datastage itself, using create tabl...

mandyli wrote:Hi

What is your target database?

My target database is Oracle

Hi ,

I have a source file containing the date as

eg:

20080120(YYYYMMDD) and i want this to be tranformed into output target table in date format, pls help me out to do so.

Thanks,
Senthil

No these characters are not accepted by UTF-8 Coding, these are converted as '?????' and written into target, thats the problem i am getting.