DSXchange

Thanks Arndw, Since i was testing in a separate Project the modification of VOC did not matter much. I created a new Project and in that ANALYZE.FILE was working . Now my query is how we determine whether the RESIZE command actually changes the size of hash file I had created a hash file whose stati...

While executing the above command from Adminstrator Command window,i am getting error "Verb does not exist in VOC".
How do we add the Verb ANALYSE.FILE in VOC?


Thanks,
Gokul

Hi , Due to some obscure requirement we had to resize one of our hash file 1. Now how do i determine whether the hash file size has changed or it is able to accomodate data > 2 GB. 2. I tried using ANALYSE.FILE hashfilename. But i got a error stating the 'VERB ANALYSE.FILE is not present in the VOC'...

Ray,
These were not interview questions.
Just trying to get more out of you


Gokul

Thanks Ray.

Hi,

I am in search of answers for the following questions:

1. What are the different types of Hash files.
2. Under what conditions we should used the specific type.
3. Performance difference in the types of hash file

Thanks,
Gokul

Hi there, In case of RCD(rapidly changing dimensions), where the frequency of change is very high. It would be difficult to keep track of all the Columns due to disk space and other constraints. In such case,Normally the dimension is partitioned into 2 tables, 1. One containing the columns,whose his...

Rumu, It is not in the stage variable. sign(source.Val - Hash.Lower) And sign(Hash.Upper - Source.val) is written where u usually specify(drag) the source column (field) which will be used in lookup with the corresponding field of the hash. Datastage will execute the above code to get a value and th...

Hi Rumu sign(source.Val - Hash.Lower) And sign(Hash.Upper - Source.val) will be evaluted first before the Lookup to yield either 1 0r 0. By this i meant that Datastage will evalute the Code (sign(source.Val - Hash.Lower) And sign(Hash.Upper - Source.val)) and then use the result in the lookup. This ...

Hi Rumu,
will be evaluted first before the Lookup to yield either 1 0r 0.

The Resultant 0 or 1 will be used to Lookup the dummy column LKP in the Hash.

So there shld be no problem in the Lookup.


Thanks,
Gokul

Hi, we were also facing the same Poblem. The Solution we developed was a crude one and Gurus here will tell us whether it is optimal or not? The Source Structure : Val id ---------------> Columns 1 1 6 2 The Lookup Table Structure: Upper Lower Value ---------------> Columns 1 4 A 5 7 B The Solution ...

Thanks Ray. Actually I was referring to one of your Posts regarding DSGetLinkMetaData,where you had specified. Code: Result = DSGetLinkMetaData(JobName, StageName, LinkName) Of course, you will need a DEFFUN in the second case, so will need to determine with what prefix DSGetLinkMetaData is cataloge...

Hi,

I want to knoe the Different prefixes used by Datastage to Cataloug Routines and Functions?

How do we determine those prefixes?

Thanks in Advance,
Gokul 10dulkar

Hi, I tested for a Job containing Universe Stage on my Local Machine.(i.e Server installed on My Local Machine). But when i tried the same job on our Production Server, it gave error. sample1..UniVerse_13.IDENT1.DSLink8: DSD.BCIPut call to SQLExecute failed. SQL statement:UPDATE "T2RngGT" ...

Hi Ray,

The Query Given will only work for Account Hash file.
What if the Hash file is not an Account file,but is created on specific Path.

Gokul