DSXchange

hi,guys I have a job is designed like this Folder-->XmlInput-->Transformer-->Sequential File. when the source file is around 800M, there will be "Abnormal termination of stage XmlInput detected. I searched in the forum, and someone said this can be solved by setting APT_DEFAULT_TRANSPORT_BLOCK_...

hi,mike
actually most of the records should be updated,not all of them.

Thanks,Mike
could you give me some suggestions about the design?
the oracle stage only do updating without inserting.
so the performance is bad.

I create a job for update records in a table. the job is design like this: DataSet----->Join(Inner)<----Oracle(Read) :o :o :o :o | :o :o :o :o | :o :o :o :o | Oracle(Update) if the dataset and oracle(read) don't have so many records, the update speed is ok. but if the Oracle(Read) output about 200 t...

try to use sequential mode when insert.

hi,all in the database, there are some tables which have foreign keys, and the tables the foreign keys reference will keep all historial records(if a record is updated, the older one is marked as 'O', the lastest is marked as 'N', and there is a column to identify the same record), now i wanna updat...

I remove the duplicated records and the job works well. thanks for help!

hi, mahadev if there exist duplicated entries, warnings will show up in the log. i have a column named site_unit, the oracle output two columns named site_key and site_unit, if the two site unit are identical, the site_key is output or the site_key is null. I am not clear about what you said " ...

hi,Ray
which partition should be used? how can i know whether this is caused by wrong partition?

i found that there are duplicated entries in the oracle output, but there is no warnings in the log.

the job use a lookup stage, the primary link is reading records from a records.ds. the reference link is a oracle stage, the records.ds have 22697 records and the oracle stage output 304 records,but the lookup stage output 68091 records.

could you please help me to find out why this happened ?

please help!

I tried char(),but the DS can't recognize the 8-bit ascii, so I must enable the NLS and set the mapping character set as "ISO8859-1+MARKS", right?

Thanks!

actually I have 4 columns have those diacritics characters, and I am not sure how many different diacritics characters will be used in the column. does that mean if I wanna convert those characters correctly, first I must enable NLS,then code as PhilHibbs post to replace all diacritics characters wi...

actually I have 4 columns have those diacritics characters, and I am not sure how many different diacritics characters will be used in the column. does that mean if I wanna convert those characters correctly, first I must enable NLS,then code as PhilHibbs post to replace all diacritics characters wi...

3 output link in a transformer link1 has 5 columns , like: 1,2,3,5,4 22,33,34,16,33 link2 has 8 columns : 1,2,4,6,5,4,3,5 100,34,23,12,55,65,77,44 link3 has 7 columns: 1,1,34,33,55,4,3 2,4,42,32,44,55,33 i wanna write them into a single file: 1,2,3,5,4 22,33,34,16,33 1,2,4,6,5,4,3,5 100,34,23,12,55,...