DSXchange

When your job score was composed, tsort operators would have been inserted. Check the score. It may even be the case that a buffer operator was also inserted.

Welcome aboard.

Search DSXchange for "vertical pivot" (another name for reverse pivot) to learn techniques.

I think you need a new keyboard fairly soon, Nani - your current one seems to be skipping characters.

Apart from "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection."?

Too busy on other matters at the moment. Things that don't need the compiler. Things such as this error message from the istool command:

istool glossary bi2bg wrote:Error occured while generating preview file : null

You can download these drivers directly from Fix Central.

Depends what kind of Windows.

For example on Windows Server 2008 R2 it's something like
C:\Users\username\AppData\Local\Temp\nn

Yes and yes.

I don't know. The structure of XMETA is too complicated for me to waste my time hacking it. Scripts do exist, and are supplied with the software. Your official support provider will guide you through their use.

The agent process is logged in as dsapi_server or dsapi_slave.

It's always the most recent setting that wins.
- in dsenv
- in project defaults
- in job parameter environment variable

You could do it with two jobs - extract into staging area (e.g. Data Set) then load from that in a separate job.

The problem is in the XMETA database. Contact your official support provider for advice on scripts for cleaning this database.