DSXchange

Hi:

Please let me know the unix command to see the running status of the job from unix.

Thanks in Advance
cnu

TRN_NUMBER in Source NUMBER(8) ,Oracle database. TRN_NUMBER in Target is int,SQLSERVER database. both are NOT NULL columns. I am using Oracle enterprise stage in source and DRS stage in Targetside. Its giving below warning. Orc_Rtetrieve_Rgw: When checking operator: When binding output interface fie...

Thanks Ray! The Oracle source column TRN_NUMBER, datatype is NUMBER(8). and also i am getting below warning, TRN_NUMBER is not NULL in source and Target,but its giving the following warning. Orc_Rtetrieve_Rgw: When checking operator: When binding output interface field "TRN_NUMBER" to fiel...

Hi: I am getting the below error when i am reading the data from oracle. Orc_Rtetrieve_Rgw: When checking operator: When binding output interface field "TRN_NUMBER" to field "TRN_NUMBER": Implicit conversion from source type "string[max=40]" to result type "int32&q...

Mahesh:

The column is not coming from source,i am assigining Timestamp() in the target side in the transformer.
The datatype in the target also Timestamp.
Its a simple i am not using any tranformation here,but giving warning.

Thanks
cnu

Hi:
Yes,datatype for the created_dt column is a Timestamp .
I have passed the timestamp directly,getting the above warning.data is also not loading because of warning.
Please advice me which convert function can i use tr rectify.

Thanks
cnu

HI !!

Can anybody knows, advice me regarding the above warning.

Thanks
cnu

Ray !!

Thank you so much,Can i select " INSERT NEW ROWS ONLY" from the update property Combo ,I think this will insert new rows only.

Thanks
cnu

Hi: I am sending the currenttimestamp() from the transformer to created_dt field , which is specified as Timestamp() in the meatadata. I am getting the below warning message.Please advice me what conversion is required to rectify the below warning. Dynamic_RDBMS_Load_Stage_tbl,0: Warning: DsRGW.Dyna...

Hi: I am using the Dynamic RDBMS Stage to load the data in SQL SERVER database in the target side. My requirement is inserting the new records only. For example im getting the 12 records from source, but 10 records already therein the target table,i have to insert only 2 records means ignore the exi...

Thanks Ray,i will try for that.

Thanks
cnu

Thanks Ray !! I want a same source date format in the target also,but there is no date datatype in the target SQL Server, only datetime is there. Is there any datatype is available for only date.We can change the metadata. Please advice me how can i get only date same as souce to the target. If I ha...

Hi guys:

I am asking about Datetime datatype format in SQL Server.
Is it only date or date and time.
Can you give me the format of datetime in the sqlserver.

Thanks
cnu

Thanks for quick reply !! I am getting date from oracle database as mm/dd/yyyy format. Datatype is Date in Oracle source. In the target Datatype is datetime.I need a same format mm/dd/yyyy in the target SQL Server also. If i map the date to Datetime field in the Transformer,can i get the mm/dd/yyyy....

Thanks !! Target is Sqlserver.So date is coming from Oracle source i form of mm/dd/yyyy.I need a same format in the target. In the SQL server DDL is Datetime. Can i map the field from date to datetime in the transformer. In SQL Server database datatype is Datetime available,date is not there. So can...