DSXchange

Thanks for giving reply..

Can you please explain me clearly



Kind Regards

Hi All I need to extract the header of the file and its detail records separately and do some validations and after that again I need to merge them together. Soure data ------------- ID|COUNTRY_ID|F2400|F2500|F2600 101|1|1001|1002|1003 102|2||1004|1006 103|3|1005||1008 I want to extract the header a...

Hi, I tried with your option but I am not able to do the same. source: ID,COUNTRY,2400 Ref data: NAME,VALUE 2400,BANK 2500,CON I was able to read the source columns as a record using hashfile and when I am trying to match it with lookup colunm name ..it gives me the result as below RESULT: ID,COUNTR...

Hi All, I have the following requirement some one please help me out.. I am Having a source records as followed. ID,ID1,2400,2500,2600 ------------------------------------------- 1234,1,100,,102 and I have a reference table with the following data NAME,VALUE --------------- 2400,BANK 2500,EDU 2600,F...

Sorry for the duplication..

I was searching for all the posts and so I thought I can post my question related to that...

Apologies

Thanks

Thanks a lot for your input. First time I was working on this stuff. Could you please help me out how to generate a header in XML output stage?? I was able to see the header option on the stage properties...and it's need to be a check box enabled ..then its asking for Load(client).. Could you please...

Hi Ernie, As you mentioned in the below post "in harder cases you'll need to parse out the response yourself, using a custom user message from the Output side of the WSTransformer, and in some cases you'll want to prepare the request envelope beforehand, along with header details ." Help m...

Hi All, We have a requirement to call the webservice to extract data using datastage. We are not able to generate header from the datastge which webservice can accept. But when we comment the header in the webservice I am able to extract the response from the service..... Any help...how to generate ...

Hi All, We have a requirement to call the webservice to extract data using datastage. We are not able to generate header from the datastge which webservice can accept. But when we comment the header in the webservice I am able to extract the response from the service..... Any help...how to generate ...

Thank you ...I will look into those...

Hi

Any sample code for this??


Kind Regards

Hi All,

I want to extract the record count of the data loaded into the target.

Some body can help me how to get the info by using a routine..some thing like as below.

pJobStatus = DSGetJobInfo (DSJ.ME,DSJ.JOBINTERIMSTATUS)

Could you pls help me.

Kind Regards

Thank you craig...

I used in the following manner...

Row generator->Transformer->Target

Is this is the way......so that I can set a flag and default the value??



Kind Regards

Thank you craig...

I used in the following manner...

Row generator->Transformer->Target

Is this is the way......so that I can set a flag and default the value??



Kind Regards

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...