DSXchange

thanks used Aggregator stage and able to count the row and write .

I am reading from seq file and have to write it in to 4 tables Headers table, Details table, Tailers table and T_ETL_COUNT. I have used 2 transformer in parallel job. for eg., seq file have 10 rows for detail ,which I am able to read that and write it in details table. But In run time : How to find ...

Still not able to fig out , and how to do stuck - not able to read the first line ( header and write in the table , and other detail rows to other table, and last line tail part to another take

Which stage should I use and give me some hints pls.

Hi, I am trying to read the seq file ( txt ). from the parellel job. I have to write to oracle table. Txt file - 1 line is header which i have to write in table 1 and from 2nd lines are the data which I have to write in the table 2 and 3th line is tail which suppose to go to table 3. eg. of the seq ...

sorry I have not mentioned that : After reading the XML file , I moving the xml data to a sequential file stage when I open the final output file , ie., the txt file , I see those ascii char in front of each column and end of the column . The above is a server job. The Same when I do in a parallel j...

Hi ASCII 167 is in front of data and end of data, I not able to cut and paste it here. when I do that ACII does not appear here . sample data"ASCII 167 char1362605ASCI 167" For all the column this Ascii Value is present when I open it from Notepad. I try to filter in the sequential File st...

HI - I try that also - did not work out. Now after few try's I got it I created in the d:\ a dir <tester> in the folder pathname : d:\tester in the Wildcard : outxml.xml It works now It is able read a XML file and write in the txt , ( now I have to try to write in oracle table ) In the text file whe...

yes I have full right to read and write all.

thanks , i will keep trying

Hi previously In the folder stage stage -> properties - Name Value Folder PathName d:\outxml.xlm AND IN Outputs -> properties - Name value Wildcard <Blank> Now I have added the below stage -> properties - Name Value d:\ AND IN Outputs -> properties - Name value Wildcard *.xlm Still Serer_xlm_read_to...

When I compile I get the below errors Event : info Serer_xlm_read_to_DB_job: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH Event : info Serer_xlm_read_to_DB_job..Cust_folder: DSD_DIROpen set &Folder& to "d:\outxml.xml" Event : info Serer_xlm_read_to_DB_jo...

Hi, I am trying to read xml file. And using server job. I am using xml input stage. window xp sp2, DS7.5.2 , server job and trying to write in a table ( oracle ). I am getting the error in the folder also. error details.. DB_job: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLI...