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.
hash file issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
Re: hash file issue
Confused... What actually are you doing ?
Look up is not done or something else ?
Look up is not done or something else ?
"Nobody is expert in Everything,
But Everybody is expert in Something."
But Everybody is expert in Something."
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?
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?
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
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.
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.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
Re: hash file issue
If you are doing a look up then why are you unchecking the mark in hash file ?
"Nobody is expert in Everything,
But Everybody is expert in Something."
But Everybody is expert in Something."