DSXchange

Hi all I need to do a job which extract a col(which is and XML column of length > 72000) from a table and place it in a sequential file. There are more than 35000 records in that table. The job structure is: ODBC stage -> Transformer stage -> Seq File stage The issue is the job gets aborted after ge...

Thanks kirthikumar. currently iam trying to do it as: ODBC--------->Trans---->XML in--->copy (input view) | | (Ref) | | -------------------->Lkup--------->(Output with all data) In Transformer generate the DummyID which will be the combination of Partition number and Rownumber. Assign this DummyRowI...

Hi all I have a job in which the input consists of 6 columns,out of which one column is in XML format. The input is a view. Example data looks like this: FirmId Mktcode XMLcol .....etc 0001 AB <start> <data1>ab<data1><data2>34</data2>.. ....</end> 0002 CD <start> <data1>xy<data1><data2>53</data2>......

Hi all iam doing a job for parsing XML input and placing into tables. The job structure is: seq_file-> XML Input stage -> Transformer -> ODBC stage Iam getting a warning at XML input stage:- Error: The link contains no derivation rules after this there are fatal errors: - Error occurred in call to O...

Hi Currently iam supposed to work with Ascential datstage, I need to create a job which has sequential file(.csv) as input and need to get a .xml file as output. I have created a paralell job which takes sequential file, XML Output and another Sequential file for storing the output. Iam a newbie to ...

Ok thanx 4 ur wonderful responses... iam really sorry 4 that question which u interpreted to be expecting the site to do my job.... Now my question is i know i have to design a server job with sequential file as input and an XML output stage. Also,i have loaded the .csv file but donno how to write X...

Hi

I have recently joined an IT firm.

Currently iam supposed to work with Ascential datstage,
I need to create a job which has sequential file(.csv) as input and need to get a .xml file as output.

Iam a newbie to ascential datasatge.
plz let me know in detail how to start and what to do

Thanks...