Missing Column in Hash File
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
Missing Column in Hash File
ColA ColB ColC
==== ==== ====
Ter 1 SPU
Ter 2 SPU
Ter 1 OCI
AUS 1 ORA
I have 3 columns in my hash file, only ColB and Column C make a key if combined. The issue is I have ColB in my source file but not Col C .
Is there a workaround for this look up.
Thanks
==== ==== ====
Ter 1 SPU
Ter 2 SPU
Ter 1 OCI
AUS 1 ORA
I have 3 columns in my hash file, only ColB and Column C make a key if combined. The issue is I have ColB in my source file but not Col C .
Is there a workaround for this look up.
Thanks
-
- Charter Member
- Posts: 130
- Joined: Mon Sep 06, 2004 3:05 am
- Location: Dubai,UAE
Missing Column in Hash File
Hi,
If u have keys defined in your Hash File then a look up has to be done against all the keys.
As can be seen from your data that values in any column are not unique and hence you have two columns forming the key.
If you create a new Hash File with only column B as the key, then the duplicates will be overwritten and that won't make any sense.
Depending on your requirement check whether you insert a COL C and hard code it to some value that can be looked up and is repeting for all the values of COL B
If u have keys defined in your Hash File then a look up has to be done against all the keys.
As can be seen from your data that values in any column are not unique and hence you have two columns forming the key.
If you create a new Hash File with only column B as the key, then the duplicates will be overwritten and that won't make any sense.
Depending on your requirement check whether you insert a COL C and hard code it to some value that can be looked up and is repeting for all the values of COL B
Last edited by Sunshine2323 on Tue May 03, 2005 6:29 am, edited 1 time in total.
Warm Regards,
Amruta Bandekar
<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
Amruta Bandekar
<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
Vinay,
a lookup stage to a hash file must use the whole key, so if it is a combined key you must know all parts of it for a lookup to function.
a lookup stage to a hash file must use the whole key, so if it is a combined key you must know all parts of it for a lookup to function.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
Multirow lookup is available from 2 stages: ODBC and the Universe stage. It is enabled from the properties of the transformer (not in the stage). One row from the primary stage will result in 0, 1 or multiple rows being available for output depending on the match on the key and the number of rows in the lookup data.
It sounds like it might work for your situation if you use the Universe stage to access your hash file. I have used multirow lookup with the ODBC stage, but not with the Universe stage. Give it a try and let us know.
John
It sounds like it might work for your situation if you use the Universe stage to access your hash file. I have used multirow lookup with the ODBC stage, but not with the Universe stage. Give it a try and let us know.
John
ds_developer - is multirow available at Rev. 6.x?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
Hi Ray,
I am using version 6.0.1 and in my job I have one source flat file, one ODBC look up, transformer and a target flat file. When I open the transformer stage, I have 3 link boxes. On the hash link when I right click or double click I donot find the "LinkProperty" option itslef!.
Can you help me out if its a version of DS issue or am I doing something out of way.
Thanks,
I am using version 6.0.1 and in my job I have one source flat file, one ODBC look up, transformer and a target flat file. When I open the transformer stage, I have 3 link boxes. On the hash link when I right click or double click I donot find the "LinkProperty" option itslef!.
Can you help me out if its a version of DS issue or am I doing something out of way.
Thanks,
Sure! Try this!
In the Transformer, don't right-click on the links themselves (i.e. the lines that join the boxes), click instead on the 'box' that represents the Hash stage lookup. Then you'll get Link Properties as one of the options.
Also as noted, you must use a UV or ODBC stage to get the extra special option to enable Multirow Lookups.
In the Transformer, don't right-click on the links themselves (i.e. the lines that join the boxes), click instead on the 'box' that represents the Hash stage lookup. Then you'll get Link Properties as one of the options.
Also as noted, you must use a UV or ODBC stage to get the extra special option to enable Multirow Lookups.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers