hash file issue

[sdfasih]

hi,
I am trying to load fact table.One lookup hash file contains two fields one of them is
key field but no lookup is done on this hash file its a direct move to the target for both fields
.But the key field becomes red in the transformer stage and gives compilation errors.
So I unchecked the key field check box in the transformer stage for those fields
now there were no compilation errors.

My question is does it will give me problems and its allright to do that?
Similarly I have single field coming into a transformer in a hash file I have to make it
as a key field to get it loaded into hash file and there is no lookup on this field so
again I unchecked
the key field check box in the transformer stage now there were no compilation errors.
My question is does it will give me problems and its allright to do that.
OR is there any another way to do it?
thanx.

[urshit_1983]

Confused... What actually are you doing ?
Look up is not done or something else ?

[kris007]

Did you try running that Job?

A hashed file must have a key column defined. Else, your Job will abort.
I am not sure how you got it to compile

Also, Is your hashed file a primary input or a reference lookup? Something doesn't make sense here. Could you be more clear please?

[kris007]

I'll slow down a little bit.

You can sure get it to compile without a key column. I also see that your hashed file is a reference lookup. Even if it is a straight move into the target field how do you intend to join those rows with the input rows coming from source without any keys to join? Your Output data is all going to be messed up. I am not sure even if your Job is going to run successfully. I haven't tried doing it anytime.

[urshit_1983]

If you are doing a look up then why are you unchecking the mark in hash file ?

[DSguru2B]

Guys guys, you scared the poor guy away. Go easy on him

[kris007]

Did I