DSXchange

The connector could not establish a connection to the default Oracle server. Method: OCIServerAttach, Error code: 12162, Error message ORA-12162: TNS:net service name is incorrectly specified. (CC_OraConnection::verifyConnection, file CC_OraConnection.cpp, line 5,088) I can view the data in the sour...

I have a Timestamp column, Ex:TO_timestamp(DN_EX_AT_DOCK_DATE,'YYYY-MM-DD') at time zone 'UTC' In oracle When we execute the above statement output is 31-MAR-13 07.00.00.000000000 AM UTC but it process it through the datastage it display this, 31-MAR-13 07.00.00.000000000 AM -05:00, But instead of -...

I need to send a file From datastage server to another server in Europe, I have Ip address,username and password of that Europe server, How to do that,, can we able to do with a command in after job subroutine or any other way,, thanks in advance

I have a table in format Code: ID Sev 1 Sev 2 Sev 3 ABC 0.45 1 1 PQR 0.45 1 2 XYZ 0.45 1 1 I want to change this to the new format as below Code: ID Severity Values ABC Sev1 0.45 ABC Sev2 1 ABC Sev3 1 PQR Sev1 0.45 PQR Sev2 1 PQR Sev3 2 XYZ Sev1 0.45 XYZ Sev2 1 XYZ Sev3 1 To bring the column names a...

I have two surrogate key columns Global_order_id(parent table) and Global_order_dtl(child table) i need to load data simultaneously into this tables,,can i generate the surrogate key for both columns in one transformer,,

Right now i am using two transformers,

That is varchar column in source and date column in target
Database-Oracle

How to convert source Input value that is 0 to NULL in target DB

The OCI function OCIStmtExecute returned status 1. Error code: 60, Error message: ORA-00060: deadlock detected while waiting for resource.


Please help me out,What are the steps to be taken to resolve that

hello chulett,

I am thinking those are hours,minutes and mill seconds,What you want me to know from business

This is what the requirement in the mapping document

99999999 - DN_TIME_STAMP = Date (example: 99999999 - 83885269 = 16114730 (16:11:4730))

Source DN_Time_Stamp Datatype=varchar
target column datatype=timestamp


what is the way to do that,,Any suggestions welcome

99999999(Said by businees to subract the value with 99999999 to get timestamp)-83885269(format we get in the source)=16:11:4730

Source 99999999-83885269=16:11:4730 timestamp value(timestamp varchar type),, What is the way to convert it into target(datatype timestamp),,please provide valid answers and help me out