DSXchange

Hi, I need to check the file status using 'Wait for file activity' If the file is available ..I will process the logic. If the file is not available I nedd to insert a record into the error table by logging 'File is not available use previous day's data' for that I need to desing the job without sou...

Hi All, I need to default a value for a particular column into the target table based on the job status As part of the job design I need to populate only this field,No other fields were not required as its just the status. eg: 'The latest data was not available in the system' Help me how to proceed ...

Hi

Once I complete the job need to sent a mail notification.. which has to come to my mailing Inbox.

but when I ran the job I was able to see the status message in my unix id....

Hi All, Iam having a problem with my email notification activity... I want to send a mail after successfull completion of my entire process. When I am trying to do that... I was able to get that msg into my UNIX box path but not into my mail inbox . Is there any specific configuration settings do we...

Thank you all...will check

Hi All, I had a requirement as follows. I need to compare todays data and previous days data based on a key column and need to Insert new records and update the existing records... scenario as follows... previous day data code ---- INR USD Todays data code ---- INR AUD I need to compare the currency...

Hi All, I had aborted my job from command prompt which is running for quite a long time... and when Iam trying reopen the same job....I am getting an error message... Is there any way we can unlock the particular job either from command prompt or within datastage?? Please advise me how to comeup thi...

Hi All When Iam using webservices transformer stage inorder to call the webservices provided by message broker ....I am getting the following error. APT_CombinedOperatorController,0: Fatal Error: Fatal: ---- response exception ---- AxisFault faultCode: {http://xml.apache.org/axis/}Call.invoke faultS...

Hi Ernie I tried creating two XML's for request and response which were stored in Table Definitions->XML->Imports And when I am trying to import the XSD using XML metadat Importer Iam getting the following error messages while importing Type'CustomerDetailsReq' is not declared Type'CustomerDetails' ...

Thank you Ernie...I will look into those possible options and scenarios


Kind Regards
Srinivas

Thank you Ernie for your inputs!! While importing through XML Metadata importer Do I need to create a separate XML table definitions for REQUEST and RESPONSE?? I tried creating the two separate XML table definitions but its not creating two definitions instead its overriding the existing one. Could ...

Hi Ernie, Thaks for your inputs. I followed the same path as you mentioned below. Assuming that the WSDL importer can at least parse the WSDL, bringing up a tree on the right hand side, open the Operation you want, select either the input or output message of the Operation, and right mouse.......sel...

Hi, I imported my XSD using datastage manager and I am trying to import my WSDL from Import->Table definitions->Web services WSDL definitions In my WSDL the XSD path reference was mentioned but not the XSD was embeded in my WSDL.S, while importing Iam getting an error as follows The XML Schema that ...

Hi All, We had requirement to send the data as an XML chunk as a webservice to message broker and we need to collect the response back to the file or database. For that ppl working on Message broker are giving a separate XSD and WSDL structure to access through the webservices transformer stage. Can...

U can use the command (ps -ef | pm dtm) and execute the command in the unix box from there u can find the process id and use the processid to kill the job