Hash Lookup Multiple values

[snassimr]

Hi !

?I need some help

How I can to arrange lookup for some values .

For example ,

I need to check if any rows with id =1 and type = 5 or 6 within hash file with keys id and type

[I_Server_Whale]

Please frame your question properly. This is NOT an Alladin's lamp.

Thanks!
Naveen.

[poorna_76]

Hi !

?I need some help

How I can to arrange lookup for some values .

For example ,

I need to check if any rows with id =1 and type = 5 or 6 within hash file with keys id and type

Specify your keys for the LookUp.

In the Transformer you need to check
"Returns Multiple Row Set" option for the lookup (link).

When Multiple rows are returned for a particular record, code your condition(if type = 5 or 6), you will be able to write out the record you are interested in.

[kollurianu]

Hi Poorna,

How would you give the option in the transformer , i mean where is the option seen .

Appreciate your time and thanks for your help in advance.

[chulett]

Hashed files do not natively support 'Multiple row result sets'.

kollurianu - it's a Link property. Get to it by right-clicking on the lookup stage from inside the Transformer.

[kollurianu]

Hi Chullet,

Hey i didnot find the option in the transformer that is linked with the
hash file , can you please tell me where it is exactly found,

Hashed files do not natively support 'Multiple row result sets'.

kollurianu - it's a Link property. Get to it by right-clicking on the lookup stage from inside the Transformer.

what did you mean by when you said that hash files do 'not' natively
support 'Multiple row result sets' ?

can we use the above feature or not advisable.

Thanks a bunch,

[chulett]

You won't as it is not a valid option for a hashed file - you'll only find that option there when the link is to a UV stage or an ODBC stage.

I'm not going into the gory details as they been posted here ad nauseum, but you can point a UV stage to an existing Hashed file and then you can get the hashed file to return multiple rows per lookup. But you need to do several things to set that up properly or it either won't work or it will work very very slowly.

[ray.wurlod]

Two choices.

1. Lookup on the key and test the returned non-key value within stage variables.

2. Create your hashed file with more than one key column, and perform multiple lookups.

Option 1 is the more efficient.

[kollurianu]

Hi All,

Thank you very much Ray and Chulet for your answers,



But how implement second option Ray, would please suggest me.


[/quote]Create your hashed file with more than one key column, and perform multiple lookups.

Thank you all lot