DSXchange

Interview question?

Moderator: please move to parallel forum

This job shows a reject link from an ODBC stage, something not possible in a server job.

From my memory below is the formula which usually give app. Array size and Transaction Size. Array size = (Pagesize - 64) / (Rowsize * 1.1). 8192 Bytes = pagesize for DWH 4096 Bytes = pagesize for Mart. Also transaction size is calculated as Transaction size = Pages per Extent * Array size DWH tabl...

It is my understanding that, to use Link Partitioner, Link Collector or IPC stage types, you must have inter-process row buffering enabled at job level, because each creates its own process. You should be able to find this advice in the on-line help for each of these stage types.

The message suggests that the data in BP_RELTYP field is larger than what the metadata specify for it.

Code 81015 is a timeout in the DataStage RPC daemon (dsprcd). Therefore you need to check that there is a dsrpcd process listening on port number 31540. Use netstat -a | grep dsrpc as the command to do so.

First thing to do is to disable operator combination so that you can be totally sure which stage is generating the error.

1. Search - this has been addressed before.

2. Don't shout.

Yes, that's what DataStage does. DataStage is an ETL (extraction, transformation, load) tool. When is the interview?

The actual upper limit is at least a fourteen digit number. It depends on settings such as EXACTNUMERIC and PRECISION.

The real table name is DS_ROUTINES (all upper case). The UV stage quotes any table name that contains any non upper case (or numeric or underscore) character. Now you know.

Interview question?

The requirement for a database is for the common metadata repository, sometimes called XMETA. This can be DB2 version 9 or Oracle version 10g or Microsoft SQL Server 2003.

Didn't even need user-defined SQL!

Search for "less than the number of input datasets". Then get your compiler and your compiler and linker environment variable right.