DSXchange

Iam getting the following message as follows:

DRS_Samp_Status_OE: Column SAMP_STATUS_ID floating point decimal is not fully supported; adjusting the scale.

How to resolve this?

How to convert date (sql type =varchar) 01/01/06 to January 1, 2006?
Could anyone tell me, about how to do.

Iam converting a string to date in modify stage using the stringtodate function as follows: C_date:date=date_from_string(date)[%dd:/:%mm:/:%yyyy] Here C_date is the new column name. and the error is coming as: main_program: Error parsing modify adapter: Expected ';' or end, got: "["; input...

Hi, Iam running a job using sequential file stage as source and oracle as target and modify stage is used.After running the job, the job is aborted and the error is as follows: Error1: DRS_Comp_Names_Ora,0: The system(sqlldr drs_gms_data01@ukdev432 CONTROL=ora.25372.7976d.0.ctl LOG=ora.25372.7976d.0...

After running the parallel job, the job has been aborted and the error is as follows:

main_program:unable to contact one or more section leaders.probable configuration problem; contact orchestrate system administrator.

How can i rectify this problem?

After running the parallel job, the job is aborted and the error is as follows: main_Program: ***parallel startup failed**** Thsi is usuallay doue to a configuration error, such as not having the orchestrate install directory properly mounted on all nodes, rsh permissions not correctly set or runnin...

After running a parallel job, the job is aborted and got the following error:

***parallel startup failed***

How can i rectify this error?

After running a parallel job, i got the following error:

main_program: the section leader on your-d36eabcf87 died.

your-d36eabcf87 is the computer name.

How can i rectify this error?

i had done a parllel job and i got the following error as follows:

main_program: accept timed out retries=4

How to rectify this error?

when i am running a parallel job.I got the following error: start up error on node1 connecting with conductor on your-d363eab87 with cookie 1098110941.8430000.fc0:unable to connect to port 110000 on conductor;socket=4, No such file or directory. your-d363eab87 is the computer name. How to rectify th...

keshav0307 wrote:in the mapping by putting the hard code value, for that column

Iam unable to do that in the lookup stage?

Iam having a Source column name as N/A.I want to enter a hard coded value ab04 in the target column by name p_code.
How do i this?

Iam having two columns as Load_Date and Update_Date.
It is an excel file and format is dd-mon-yy.
How could i transform these values in datastage using transformer?
Iam loading into Oracle.

How to find out the difference between the two jobs?

How to write the conditions in Tranformer Stage regarding the source column and by default its length is 10.when a column value contains more than 10 charcters the job should abort?
How to write this condion?