OK... I'm going to ask again. Is there anyone there you are working with onsite that knows the Server product and whom can help you with this? Sorry, but you are asking very basic questions on very basic issues and people here are really not meant to be a substitute for proper training. Not to mention that these kind of lessons are best delivered in person, hands on, in an interactive manner.
And I for one don't have time to type up a whole "Hashed Files 101" lesson right at the moment... or any other time, really.
Improve performance
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Oct 01, 2008 10:30 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
You don't "pass multiple rows" to a reference link and a hashed file stage cannot return more than one row per lookup - both are singleton operations mandated by the "destructive overwrite" nature of a hashed file which does not allow duplicates per key. If you really need to return multiple rows then you must use either an ODBC stage or a UV stage (which can sit "on top of" a hashed file) and is why I asked the question earlier on.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi Vishal,
To make multiple rows to the hashed file use composite key. But if the requirement is to have duplicate data in the hash file (which I presume will not be the case) then hash file cannot be of use.
Also in the previous posts, there is a mention of not using keys in the lookups. Wondering how can lookup be done without using key columns . Even if there is an use of Stage variable, only the first row is going to be compared always
To make multiple rows to the hashed file use composite key. But if the requirement is to have duplicate data in the hash file (which I presume will not be the case) then hash file cannot be of use.
Also in the previous posts, there is a mention of not using keys in the lookups. Wondering how can lookup be done without using key columns . Even if there is an use of Stage variable, only the first row is going to be compared always
222102
There have been times when I've built a reference lookup without keys, but it is rare and it can't be done against a hashed file. And it only really makes sense when you either need to return a static value (and then you'd be way better off pulling that into a hashed file with a hard-coded key) or for doing something that requires no 'where clause' - for example, when selecting NEXTVAL from a Sequence object in Oracle from DUAL.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers