DSXchange

Are you correctly identifying the host name when trying to connect from work? Try using the IP address rather than the machine name, to eliminate the possibility that gethostbyname() is the culprit. Tried connecting using only IP address. Same result. Breaks connection when attempting to save or co...

Are you correctly identifying the host name when trying to connect from work? Try using the IP address rather than the machine name, to eliminate the possibility that gethostbyname() is the culprit. Tried connecting using only IP address. Same result. Breaks connection when attempting to save or co...

Do you have the Ascential DataStage XP SP2 patch installed? I have installed a client side patch provided by IBM. It updates the following dlls: jobseqpages-<rel>.dll - client patch component (7.5.1) jobseqframe-<rel>.dll - client support dll dsguictrls-<rel>.dll - client support dll dsjsjobgen-<re...

Do you have the Ascential DataStage XP SP2 patch installed? I have installed a client side patch provided by IBM. It updates the following dlls: jobseqpages-<rel>.dll - client patch component (7.5.1) jobseqframe-<rel>.dll - client support dll dsguictrls-<rel>.dll - client support dll dsjsjobgen-<re...

Does your laptop have a VPN ? How are you connecting to the Datastage server? Yes. My laptop has VPN. However, I'm behind the firewall and connecting directly to Project. Hosted on a Linux server. I can open the jobs fine. But I can not save or compile any existing job. If I create a new parallel j...

Yesterday I have moved to a new laptop, which was recently upgraded from XP Home to XP Pro SP2 and then installed the DataStage 7.51a client. Now, when I attempt to save or compile a job, I receive an 81002 error (See below). Some other points to note: Occurs for any datastage userid used on the lap...

Hi, If you are ready to use Lookup stage, you can perform range lookup from the same. You can make use of the 'condition' option avaialable in the lookup stage and check for your condition trans_date >= lkp.effective_dt and trans_date < lkp.expiration_dt :D -Kumar :? I'm not sure I understand your ...

Hi mczern. Type 2 slowly changing dimension is really common in the data warehousing world!!! If the data you're loading correspond to current data, it's easy... all you need to do is extract only the current image of your dimension and lookup against the key... in other words, in the SQL statement...

Being new to Enterprise Edition I can't figure how to perform a lookup against a type 2 slowly changing dimension table. I need to perform a lookup to return a surrogate key against a table whose natural key value is id, effective_dt, expiration_dt. Has anyone implemented a solution for doing a keyl...

Funny, this question has the same answer in a different form from this one which was posted at almost the same time :D No, DataStage strings are not allocated as the contiguous memory blocks which most compiled languages use. This is a strength of string handling in DataStage, since a string can be...

When creating additional DataStage columns in a Flow, does the allocation size make a difference in the speed of the data Flow? I've created new fields in my Flow as varchar(1000). The size of the data is never expected to reach this size, however if the column is the concatenation of several other ...

Your reference lookups are against all 12 million rows? Are these dimensions? Why are you dumping the whole table to a hash file, why not just get the rows you need? If you took all of the distinct natural keys for each dimension in a typical run, I bet you would only require a vastly smaller numbe...

My guess is that there's a little more action happening between the ORAOCI stages, potentially a hash file that's getting too big or something else. We need a little more info. A little background... The job used to run to completion when all hash file lookups were used within the job. We are attem...

Funnily enough, and despite what Oracle bin Larry would have you believe, there are other databases than Oracle. SYS.MESSAGE is a UniVerse table. You can query it from the Administrator client Command window, or from a TCL prompt. TCL is UniVerse (DataStage) approximate equivalent of Oracle's sqlpl...

Hi, You are running out of space. You need to allocate more amount of space for the target object or reduce your records Note - It is segment violation error. If you query the sys.message table, you will find description for this error (911) Ketfos Thanks All for the help! Great tips to help me in ...