DSXchange

"George - you meant to say "in any SQL compliant database". Pick type databases such as the UniVerse/DS engine work differently. Hashed files cannot be created without unique keys, the terms "key" and ... " Thanks Arndw; Again half only.... :cry: Thanks George sebastian...

Sorry Everyone, I dont know whats happening while i click on submit button to post,i am receving an error"Failed sending email::PH:: Debug mode. So again i clicks on submit But the post in infact has published in the 1st attempt even though it has shown an error. so thats why the same posting a...

Yes, and this option will only appear if the Reference Link originates from a UV or ODBC stage. Thanks Craig, Thats a new information to me.Is there any special reson why only for UV and ODBC why not for OCI,DRS etc Sorry Craig,I am not a premium member thats why i was not able to see your first po...

Yes, and this option will only appear if the Reference Link originates from a UV or ODBC stage. Thanks Craig, Thats a new information to me.Is there any special reson why only for UV and ODBC why not for OCI,DRS etc Sorry Craig,I am not a premium member thats why i was not able to see your first po...

chulett wrote:Yes, and this option will only appear if the Reference Link originates from a UV or ODBC stage.

Thanks Craig,

Thats a new information to me.

Sorry Craig,I am not a premium member thats why i was not

able to see fully your firstpost.

Thanks all
Georg

JoshGeorge wrote:In Transformer stage properties you can check the option for reference link with mutli row result set and enable this.

Thanks Josh,

So if we check this option and in the lookup there are multiple rows which are matching the key,all these rows will be selected?

Thanks
George

JoshGeorge wrote:In Transformer stage properties you can check the option for reference link with mutli row result set and enable this.

Thanks Josh,

So if we check this option and in the lookup there are multiple rows which are matching the key,all these rows will be selected?

Thanks
George

JoshGeorge wrote:In Transformer stage properties you can check the option for reference link with mutli row result set and enable this.

Thanks Josh,

So if we check this option and in the lookup there are multiple rows which are matching the key,all these rows will be selected?

Thanks
George

No index is created on the key. Hashing algorithm is much faster than using an index. Indexing key columns individually will only help if you run queries against the hashed file in which the repor ... But Ray in any database when you specify a key automatically there will be indexing on that column...

No index is created on the key. Hashing algorithm is much faster than using an index. Indexing key columns individually will only help if you run queries against the hashed file in which the repor ... But Ray in any database when you specify a key automatically there will be indexing on that column...

No index is created on the key. Hashing algorithm is much faster than using an index. Indexing key columns individually will only help if you run queries against the hashed file in which the repor ... But Ray in any database when you specify a key automatically there will be indexing on that column...

No index is created on the key. Hashing algorithm is much faster than using an index. Indexing key columns individually will only help if you run queries against the hashed file in which the repor ... But Ray in any database when you specify a key automatically there will be indexing on that column...

The secondary indices on hashed files are something completely different and are not used from DataStage. The indices created by CREATE.INDEX and BUILD.INDEX are on columns and are accessed when doing ... Hi arndw, I am sad to tell that i am not a premium member so i was not able to read your post ...

Can anyone please explain this
When i searched i got only one thread
viewtopic.php?t=109355&highlight=VOC+entry

Thanks
george

Hi all, When we create a hashed file with key columns, Indexes will be created for those columns Isntit? If yes which one will be better/performance making columns as key or creating Index by Create.Index Then will there be any advantage or difference if we create indexes for those columns separatel...