DSXchange

Hi, To add to the comments Write a query. Add a column(which should be unique ie 1) to the source files using the column generator. select nvl(max(ACCT_SUR_KEY),0) as ACCT_SUR_KEY,1 as DUMMY from ACCOUT. Do a lookup between the newly generated column and the dummy from the table and propagate max_va...

No Only Error Message.

Regards,
Bala.

Hi Ray,

Its 7.5.2.

Regards,
Bala.

Hi, When i run the sequence i am having a error. My os is Windows XP.anyting can be done to solve this. I am not getting any error for other jobs. main_program: **** Parallel startup failed **** This is usually due to a configuration error, such as not having the Orchestrate install directory proper...

Hi Kumar/Istsaur I have set the PWD variable pointing to my project now that warning is gone but still i cannot compile it. Regarding the setting of the library path.I have folder which has the C code,object code and executables.I am browsing and giving that in the library path is that right because...

Hi Ray/bachu,

Thank you very much its working fine for the records which has got the exact format(%mm/%dd/%yyyy)but in my source i am having some records like 1/1/2006(month,date,year) here the month and date are not in the proper format so it issues a null in the target.

Regards,
Bala.

Hi,

I need to convert a input field which is string to date.Eg(1/12/2006).
I am using the function date_from_string(input column)..I am getting a fatal error.But when i use a proper date like 2006/12/01 the function is working fine.How to solve this problem.

Regards,
Bala.

Hi Sud, Thanks for the reply.Exactly what you have mentioned is right.I am asking a way to pass the source URL to the XML Input Stage. Example:-I am the XML content in location say D:\customer.xml. Do you mean to say if i pass this location as the URL in the input tab of the xml stage it will work.I...

Hi, I have worked with server Edition and extracted data from XML inputs. There was a stage called folder stage which takes two columns in the second i will the contents.in the input of the XML input stage i need to mention abt the contents either as a columns from folder stage or URL. How can do th...

Hi Istsaur, Thank you very much for the reply. I am using a Turbo C complier to create the c program(complied,sucesssfully ran there),it creates the object code as .obj and an executable file *.exe. Now in my library path when i give the object file its showing an error. .NET 2003 C++ compiler is in...

Hello All, I have written a c code which takes 2 arguments and adds it and return it to the main program.I have compiled and sucessfully got the result.Type i have taken care. I want to call this external function in my stage.I am using a parallel routine. In the routine,I am giving the libary path ...

Hi,

Extermely Sorry can i move parallel forum if so how can i do it.

Regards,
Bala.

Hello All, I have written a c code which takes 2 arguments and adds it and return it to the main program.I have compiled and sucessfully got the result.Type i have taken care. I want to call this external function in my stage.I am using a parallel routine. In the routine,I am giving the libary path ...

Hi Maneesh,

You do not have DBA priviliges to the user you are accessing.Contact your database administrator to grant dba to the user you are accessing the tables.It will work.

Regards,
Bala.

Hi, I am using Oracle 10G. One of the field in Oracle is of number(8). When i import it through Plugin metadata definitions i am getting the datatype as decimal(8,0). When i import it thro Orchestrate schema definitions its giving me int32 for that particular field. When i use the Orchestrate schema...