Hash File Problem...

sivatallapaneni · Post by **sivatallapaneni** » Mon Mar 08, 2004 2:53 pm

Hi,
I'm having probelm with hash file. I created a hash file in the a job and viewed the data, all the data fileds are populated and every thing looks fine. then i save the table definition and build one more job to use the hash file as a lookup when i viewed the data in this job in the data browser some of the columns are not populated with the data. i have a key defined and did every thing. i have no idea why those columns are diplayed in the data browser without data. did anybody face this before? any inputs are appreciated.

thank you.

kcbland · Post by **kcbland** » Mon Mar 08, 2004 3:13 pm

You have a metadata problem. If you swear that the metadata in the reference stage is the same as the metadata in the job that creates/populates the hash file, then recheck the name of the hash file and/or the path.

sivatallapaneni · Post by **sivatallapaneni** » Mon Mar 08, 2004 3:30 pm

Metadata is same, hash file name is same. and also giving the right path. data is visible in some of the columns i dont know what's happening with the other columns.

Thanx for the reply though.

kcbland · Post by **kcbland** » Mon Mar 08, 2004 3:33 pm

If you have a hash file and two jobs have the same exact definition, then viewing data in both jobs should show the EXACT SAME ROWS. It will read the hash file the same way/order, so the first row listed in both jobs should be the same row. Is it?

If not, you're looking at different files. If it is, then it is the metadata. If that same first row has columns shifted, then it's your primary key definition. If the columns are just blank, then please state that.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 08, 2004 3:42 pm

Scroll to the right in the Hashed File stages' Columns grids and verify that the Position column information is the same in each. Identification of fields in hashed file records is by Position rather than name, if Position is supplied.

sivatallapaneni · Post by **sivatallapaneni** » Mon Mar 08, 2004 3:50 pm

There's no shift in columns. columns are in the same position. only some columns are balnk in the second job.

kcbland · Post by **kcbland** » Mon Mar 08, 2004 3:51 pm

You did not answer my first point about verifying that the first row listed is the same in both hash file viewings.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 08, 2004 3:56 pm

sivatallapaneni wrote:There's no shift in columns. columns are in the same position. only some columns are balnk in the second job.

You've missed the point.
What values are in the Position column in the Columns grid?

sivatallapaneni · Post by **sivatallapaneni** » Mon Mar 08, 2004 3:57 pm

There's nothing in that, blank.

sivatallapaneni · Post by **sivatallapaneni** » Mon Mar 08, 2004 4:06 pm

I closed and reopened my connection and it workd fine now. i did that before also, it did work that time. I have no clue.

Thanx guys for the replys.
Have a good one.

pongal · Post by **pongal** » Fri Mar 12, 2004 2:52 am

lot of convesations went .. good. All given perfect information on how to tackle hashfiles.

i think you have not selected correct key fields in HashFile.
Key fields whatever there in Source should have to match in Hashfile also.

Here i'm listing some points below while comparing or poplating the data.
1). Please check the datatypes and datalengths should have same as that of same while comparing any fields.
2) while comparing , always use Trim function for each referencing Field.
3).Its better to keep only Key fields and other neccessaty fields for Transforming or loading the data to the destination Table or file.
4).Order of the columns must be mathched.
5). Filename and location must me matched while using the same hashfiles in no of jobs.
6).sometimes if there are no key fields on Source while populating to hashfile, if you put dummy key fileds, it will not compare correctly.
cheers.........now you can happlily work on hasfiles without ruin your confidence.

pongal · Post by **pongal** » Fri Mar 12, 2004 2:56 am

lot of convesations went .. good. All given perfect information on how to tackle hashfiles.

i think you have not selected correct key fields in HashFile.
Key fields whatever there in Source should have to match in Hashfile also.

Here i'm listing some points below while comparing or poplating the data.
1). Please check the datatypes and datalengths it should mach with the Source structure while populating the data 2) while comparing , always use Trim function for each referencing Field.
3).Its better to keep only Key fields and other neccessary fields for Transforming or loading the data to the destination Table or file.
4).Order of the columns must be mathched.
5). Filename and location must me matched while using the same hashfiles in number of jobs.
6).sometimes if there are no key fields on Source while populating to hashfile, if you put dummy key fileds, it will not compare correctly.
cheers.........now you can happlily work on hasfiles without ruin your confidence.