DSXchange

If input files are from different link, use transformer or modify stage to add the buffer field and use funnel to consolidate all.

HI,

Is the error for only few job or for all the jobs to import?
By any chance did you edit the exported dsx file?

Search will give your more results.

Search for the same.
This topic has been discussed many times. Go thought the documents. find the posts. Specific queries can be still answered.

http://www.dsxchange.com/viewtopic.php? ... et+fileset

http://www.dsxchange.com/viewtopic.php? ... et+fileset

http://www.dsxchange.com/viewtopic.php? ... et+fileset

http://www.dsxchange.com/viewtopic.php? ... et+fileset

Are you using the routine to check the values and assign to the fifth field?
If so what are the values for the field 1-4 for the row where field 5 is null?

After going through the suggestion given, try using clear status file option available in DS Director.

Is the field Rate_WA in update file being constantly dropped in all the join stage?

Welcome aboard :D Search for the same in the forum you can find lot of informations related to this. You can derive you own logic to generate the surrogate key using transforer. That may even include the avaiulable keymanagement utility as a part concatinating with the run cycle number...etc based o...

Since in the first job, Null is assigned to all the fields and the respective flag values 'Y' or 'N' is assigned in the second job, the condition given to the field should be verifed. Also you get the value of the flag for most of the rows, so you may concentrate on the logic given. Or share the log...

Try to replace the database stages into sequential file. If you see the diference, pre populate the databse into a hash file and do a lookup. May be the query hit by the stages to the table for each records in a sparse lookup may lead to slow down of you job.

obviously u will be getting excess records I dont think so any Bug in join stage.u are using left outer join the link from left all rows u will be getting it. and the matching records from the right link.just see through the link ordering. Even in this case, the number of output cannot exceed the n...

Otherwise, read the whole record as Varchar 255 and check for the delimiter ',' and replace with required characters if missing in a transformer.

Just check whether you are able to get some information from Even id 108, from the log of that particular job.

Also look into 'Warn on Reject Updates' and 'Warn on Unmatched Masters'

arasan wrote:1.Data set it works through DS engine.
2.copy stage it will be very use full for taking DUMP. you can check data is passing properly.

Dump can be taken directly from dataset too.