DSXchange

Thanks you Andy.

I am trying to read a CSV file and then load that data into a table or a file. I am not getting any idea on how i can achieve this. It is somewhat complex for me. Can you give me some idea on how i can do it ? I just showed 9 lines here but my spreadsheet has thousands of lines so i am trying to fin...

Hello All, I have monthly jobs,weekly jobs,quarterly and daily extract jobs. these jobs will extact data based on current run date(sys date) and extract data for previous week or previous month and create files. I don't have date dimention instead I have a oracle created_date column in table and i a...

Thanks Ray and Ernie.

Hi, We are getting data from database and generating XML. Requirement is output XML has to close and open new tag after every 3 records. I am using XML Input stage to generate XML. Here is the sample XMLi have to generate. <CustomerData> <TRANSACTIONID>1</TRANSACTIONID> <PLATENUMBER>JUNE618</PLATENU...

Thanks Craig. Can anyone please give me some idea on this?

Hi I have a requirement like this. I am using Server Job and trying to generate XML's using XML output stage Hash Files(3) . . design Seqfile -->transformer --> XML output input file has 5 columns and 3 are key columns input data policy_eff_dt policy_exp_dt policy_no region_id vehicle_id 1/1/2011 1/...

Thanks Ray. So we can not give cc list right ? I am asking this because there is a requirement to add cc list to different client group. If it is not possible then I have to go and tell my boss that we have to send mail to all IDs using TO addresses only.

Hi ,

Is there any way we can add cc list while sending email through notification activity ?
Thanks in Advance

Thanks for the quick reply. I sent the output to 1 string and fortunately it is giving all data in XML tags and I used XML input stage to split into multiple rows. All worked well. Thank you

Hi,

I am using web service client stage to call a WS which will return multiple rows (5 columns).
but the data is returning in a single row (for all rows)
all rows data in a column is appended in that column.
How can we split this data into multiple rows.

Thanks in Advance.

lstsaur wrote:Junks in, junks out .

yep . thank you..

Hi All, It is working at last. as expected it is void arguments only. i did not try a new service but same wsdl but i sent a dummy argument. from yesterday i was sending but today i sent a dummy argument and in the mapping field i gave method name like this "/ns1:retrieveContRequest/CustomConWe...

Hi All,

How can we save WSDL to a file and configure web services pack manually. saving to a file means save as xml and use xml meta data importer? I have an issue with datastage not reading one of 2 methods in a wsdl, so i want to try this option. Please advice

However, if I saved the WSDL to a file, and used that, DataStage found the operations. Hi, you said you saved WSDL to a file. What do you mean? how did you do that. I also have an issue recently that i datastage can not read one of 2 methods in a wsdl, so i want to try this option. please let me kn...