DSXchange

You may also need to remove entries from UV_SCHEMA. Search for information on VERIFY.SQL command.

I don't believe the internal representation (UV-UTF8) has any bearing. It's probably time to involve your official support provider.

(They will probably advise uninstall and clean install of 8.1.)

Set $APT_DISABLE_COMBINATION to True to ascertain which actual stage is throwing the error.

What's your confusion? If data are partitioned on A, B and C then - for any particular combination of A, B and C - all values of D will be on the one node, so grouping by A, B, C and D will yield accurate results. Performance is immaterial, there's only one way to get the correct result, namely grou...

Change your default NLS map to something other than UTF-8 in the 8.0 project.

It is very urgent from my side. Urgent queries should be directed to your official support provider and, if you need an urgent response, you probably need to sign up for priority service - where you will learn just how much "urgent" is worth. DSXchange is an all-volunteer site whose membe...

SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%'; -- number of jobs in project (all types) SELECT COUNT(*) FROM DS_JOBS WHERE JOBTYPEIND = '2'; -- number of job sequences in project SELECT COUNT(*) FROM DS_JOBS WHERE JOBNO IN ( SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD<8>&quo...

When libraries can't be found, check the shared library search list. This is the environment variable LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH, depending on which operating system you're using.

As far as I can determine Oracle 11g is not yet supported. However, there is a new version of Information Server due out any time soon (my guess is late May) and support for using Oracle 11g might be in that. There are no restrictions on what you use for the name of the common metadata repository, I...

If you can remember what it was called you can search the file systems for it.

Welcome aboard.

Always avoid re-inventing the wheel. ETLstats, which you can download free from Kim Duke's website, will do all of this and more.

No.

You will need to attempt all the lookup and go with the first non-null result.

This is not a RANK function.

Hmm...

Thanks. Need to tweak the training materials a bit!

The "target instance" here is the job definition record in the XMETA database. Apparently (from the message and your description) a locking issue was encountered.

Welcome aboard.

mfshah wrote:The jobs should be dynamic/flexible and pick the metadata information at run time

Why?