DSXchange

The problem was solved by getting hint to aggregator about sorted data

Nothing

I use Aggregator stage to remove duplicated rows on source and it has return the following error : DataStage Job 82 Phantom 2228 Program "DSP.ActiveRun": Line 51, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage LoadDW_FACT_VISITS..Agg...

How to configure 64-bit usage hash file ?

If it already on forum show me the link , please ?

Hi ! I need help in hash files. I need create hashfile 20000000 rows with 6 keys . It to slowly. I want to create hash file with one key that is faster and go to Inputs-> Columns and add 5 keys that I needed before and use the file with 6 needed keys in another place. I don't suceed because the some...

Hi !

I wonder if I can to get list of all tables are defined on DS Project as Source or on ODBC Stages ?

I want to call routine of DB2 AS/400 and get output into DS

Any body can help me ?

Thank you all . And let me know when MS SP supported....

So the point that the memory size must be more than hash file size ? It not enouthg low ratio ? I work on Windows. "If you have a large hash lookup table and your source is sorted in such a way that the key used to lookup into this hash file is usually the same then a memory file would make sen...

Hi!

Does anybode can show me the code for calling Stored procedure on SQL Server.

I need help with this.

Hi !

I have perfomance question.
It was said that using "Pre-load file to memory" for hash file useful if the operational memory comparable with hash file size . The question is
When the perfomance start decreasing . I f the ratioo is 1:10 , 1:100 ?

Does anybody discover rule of thumb ?

How I can find out the numeric key ?

0002 $INCLUDE SYSCOM FILEINFO.INS.IBAS

^
No VOC entry for INCLUDEd file "SYSCOM".

To Chullet :

I need to know hash file physical size because I requerid not to produce then over thhen 100Mb

Thank you . But I need vb code

Yes . I need VB code that may be placed within routine