DSXchange

ray and roy,
Thanks for the help. That was how I was kind of thinking it through, just wanted to verify.

Marc

I have a situation where I have a Hash file that I need to use as a lookup for descriptions to insert into a larger sequential file. The problem I am having is that the join to the sequential file depends on a value in the hash file, for example: key Level Code Desc ______ ____ ________ ____________...

Ray & Kenneth,
Thanks much for the help, the suggestions pointed me in the right direction, build time is less than 2 minutes.

Cheers

Ray,
Thanks for your input. I do not consider this hash file to be very large, around 65 Mb, approx 1.2 mil. records. I will try to use the write caching, right now, it takes around 30 minutes of wall clock time to build this.

Thanks Kenneth!

I have a server job that is trying to build a HF for lookup purposes. It seems to slow down immensely as it progresses. The source file has approx. 1.2 mil records in it. I am using the type 30 dynamic hash file and the records being returned are 3 fields, 2 keys and the lookup value. The job starts...

Thanks Ray, I will do so.

I have 1 input file and 2 hash lookups. I want to direct records that have a 0 for account number into my reject file and the rest go to the next transformer. Rows are being written to the reject file and the next transformer, ie it puts them into both locations. For example, my log will indicate: 1...

Hi All, Can we use BCP to be loaded in Sequential Files. If yes how can we do it. I see only options to a SQL Server. Thanks Krishna How would you bulk load to a sequential file :wink: ? Bulk loaders usually take a sequential file and dump it into a database by sidestepping a lot of database checks...

Ogmios,
I rebooted, to no avail. I can't get to the Link to rename it, also I cannot view the properties on the output file, It seems like the job has become corrupt or something. Any other suggestions are very much appreciated.

Marc

I just went into the job to check the contraint, now, DS is giving me an OLE error. hmm.

Being fairly new to DS, I have a job that I was finishing up and wanted to change the names of the input links. After renaming one, the job won't compile, even though the link name appears in the diagram and in the transform it is the same. Any hints on what to do to fid this?

Thanks
Marc

Hi All, Just trying to get on what people think would be a good perfoming way to merge header and detail files together. I was thinking about going the merge stage route, but thought hash files would be a better performing solution because only a couple of fields from the header file make it to the ...

Thanks Kim, I will check all of those things out. It has to be something like what you said. I changed the job to use the db table that the hash file is built off of and it works fine.

I have a job that is using 2 hash files and 1 sequential. It basically reads the 2 hash files for lookup purposes and then inserts a field from each in addition to the output of the seq. file. For the life of me I cannot get 1 of the hash files to score any hits, even though I know it has a key matc...