DSXchange

Thanks Ray, I thought so. Only reason I wanted to see if this functionality can be achieved in Modfiy stage is that I wanted to reduce the usage of transformer wherever possible but given the scenario I might have to use one I think.

Hi,

I am trying to use the Modify Stage to handle Null for one of the column by replacing with value from another input column. Is it possible ?

Specification that I have tried but didn't work looks similar to the one below.

Ex. COL2 = handle_null (COL2,COL1)

Thanks
Arvind

Hi Ray, I don't have any idea about XMETA database. How do we find out that XMETA database is available in first instance? How to access it? What Stage in DataStage to be used to access the data in XMETA database? Could you point me to the XMETA DATABASE dictionary or any documentation that you may ...

Hi, We have A requirement to store all the datastage components information into an Audit table having following metadata PROJECTNAME (Name of the project) OBJECTNAME ( like Jobname, Sequence, tabledefinition,shared container..etc) OBJECTTYPE (Job or sequence or shared container or others) FOLDER (D...

Thanks Arndw. I searched further and then got this link to understand the steps to compile the C code; however, I dont know where the object file would get created . I searched in the directory where I kept the C code but it is not there . Also, I don't have much knowledge about buildOps; however, e...

I am looking for the method of how to compile the written C code in Unix and to generate the object file to refer that in parallel routine.
i.e.
What is the compilation command?
Where will the object exists after compilation?

But still looking for a parallel routine to make it bit more reusable. Any help please how to use it?

Hi, We have arrived at a solution in UNIX to implement the touch file mechanism with the following steps using a UNIX script. 1) Script touches a file in a directory where all the source file arrives 2) Based on the modified date of the touch file, look for any files in the directory <= Touch file m...

Thanks ArndW. You are a star :) - Double convert function worked. used the following simple steps: stagevar1 - "0123456789" Stagevar2= Convert(Convert(stagevar1,'',inputdata),'',inputdata) It returned all Numeric value. Great. Spent unnecessary effort researching parallel routines, even le...

Hi Members, I have a requirement to standardize the incoming telephone number data in few columns to remove all alphabets, special characters and return only number. Ex. If I have a data like "(404)- Ns@-(0123456789)" it should strip of all Symbols, Special characters, alphabets and return...

Hi, I have a requirement where I need to delete an incoming row from table 1 and insert or update a row into table-2. At the moment, we have delete and insert option where I delete the record from table-1 using a user-defined query and insert user-defined query to insert the row; however, we are fac...

Hi, My requirement is to create & post xml messages to a Message Queue and if successful update the source oracle table with the status for the corresponding message source record. To tie back the rejected xml message to the source record, I am trying to pass the "PRIMARYKEY" col to th...

Thanks Chulet for your quick response. I didn't notice that it establishes connection at the start. I may have to request DBA to bump it up. However, just to understand, when I worked on Server jobs I don't think I have faced such issues. Opening connections at the start, Isn't it a overhead for Dat...

Hi All, We have faced a strange error in DataStage at the target Oracle stage saying "ORA-03135 Oracle Connection Lost". My parallel job design has source file input -> transformations-> Write to Oracle Since the data volume is so huge it takes minimum 2 hours to complete and atleast takes...

Yes, you are right, we have done such scenarios in server job wondering now how to do it in parallel ...