DSXchange

Anupam, Start learning as much as you can about 8 (the "Hawk" release) as soon as you can. It is radically different. It uses a services-based architecture, it is not UniVerse-based under the covers any more, all Manager functionality and QualityStage functionality is incorporated into Designer, all...

Of course. If you've committed, then the rows are in the tables. IF you're loading the tables via multiple input links to a single ODBC stage, then you can use transaction grouping to hold back any COMMIT until all rows are loaded into all tables. This can lead to huge transaction sizes, which may c...

I'm working on a 7.0 site this week, and it's horrible not having the job sequencer goodies such as expressions everywhere. You know what the issues are, you can avoid them. In general no upgrade of the product will improve performance. ETL performance is primarily a function of efficient design and...

You were running this in the Debugger. Does the same occur if you run the job without using the Debugger, and without using stage tracing? I have not seen that particular error number before; I suggest you report it to your support provider - they should at least be able to decode the number! Your j...

if u have any matching key between the dataset then u can use the lookup condition in look up stage to give the between logic. Can you be more specific? I understand that the lookup condition property determines whether the lookup is performed at all; if this condition is satisfied then the key val...

Depends. Probably about the same, given that you told us it's a server job. Not much changed there. Big changes in job sequences (more activities), and some changes in the way parallel jobs work. Read the readme file that accompanies 7.5 for more complete information about what changed.

If urgent help is required contact your support provider and sign up for premium support. This is an all-volunteer site - we don't do urgent. May I suggest that you're not the first to encounter a segmentation fault (note: no capitals) or segmentation violation; there is a Search facility in the men...

It's not undeclared so much as uninitialized. When you create stage variables, make very sure that you always give them an initial value. Of course it may not be a stage variable that's causing this message. It may (for example) be a variable within a routine that's not assigned, which may mean that...

Look at things that limit how large files can grow, such as free space on disk, the executing user's ulimit settings, whether there is a quota on the directory, and so on. It's impossible to diagnose with so little information. Your question is akin to "I drive my car for 120km then it stops. Please...

No idea. I'm not an Oracle DBA. Why don't you ask your Oracle DBA?

Is there a convention for naming the input link? If not, how do you propose to create an algorithm to request the row count from the input link? (Do it in English - we can get it into code later). Create a job that is a job control routine only. Here is its algorithm ( not its code): For each jobnam...

Welcome aboard! :D

Tell us more about your job design. Are you using vectors, subrecords or tagged subrecords?

View the generated OSH, find the modify operator and check out what's happening nearby. Also check what's happening in and around the sort operator (obviously).

Umm... "official"... hmm...

Don't know of any.

The best advice on best metadata practice, imho, can be had from Metaview360 - as it happens one of the sponsors of this site. Even if you don't buy their consulting or training services, there are some useful papers on their web site.

That will really impress your DBA.

How about the system and statistics tables that describe how big database objects are?

Do you really want to know about how it detects deadlocks? It's horribly complicated, involving lock tables, lock waiter tables and analyses of circularity (a deadlock does not necessarily involve just two processes!). It's the secondary task (of freeing up locks and shared memory held by defunct pr...