DSXchange

This could be a bug introduced into the MSOLEDB stage - or it could be that your connection string is not as correct as you believe it to be. Double check the latter then involve your support provider. Can you connect to Access via ODBC? Have you successfully built and tested a Connector for this MD...

Fiddle with priorities ("nice" numbers). Give the Oracle cluster communication process a tad more priority. Your assertion is somewhat surprising, because DataStage processes operate as background processes and should automatically receive lower priority as a result. But, then, oprocd.bin probably r...

Take a look at QualityStage. Your requirement is precisely what the "Survive" stage does - consolidates groups of candidate duplicates into a single record containing data from all candidates (where appropriate) so as to generate the "best of breed" record - the one containing the maximum amount of ...

Welcome aboard. :D

Where, precisely, did these message get logged? What is the name of the log? What was happening when they occurred? What else was happening on the machine? Were you monitoring CPU and memory at the time and, if so, what was happening vis-a-vis these resources?

On the down side, lineage analyses will not be reliable if you use RCP - the columns will appear to have magically appeared out of thin air.

Use a Sort stage and let it generate the Sort Key Change column, which is exactly what you want.

In a word, no. A good starting book is The Data Warehouse Lifecycle Toolkit by Kimball and others, ISBN 0-471-25547-5, especially sections 4 and 5.

Read the manual chapters carefully. Emulate the examples therein. Then ponder your specific requirements again.

Where is the record schema that shows what is a subrecord or a vector?

Won't work. The missing columns will still be treated as empty or null and pivoted, as long as five input columns are defined. It has to be post-processed.

This precise question has been answered before. Search for "transformation extender" or browse the TX forum.

IBM now offers a class coded DX800 (What's New in Version 8.0). I'm not sure if it's release to the public yet, so watch this space.

Oracle, as is its wont, does things differently from the rest of the world. WE means Western, 8 means 8-bit. The 8859 refers to the ISO 8859 standards, and the P1 means part 1. For the rest of the world the name of the character map is ISO8859-1. MSWIN1252 refers to Microsoft Windows code page 1252,...

Nothing to elaborate. It's all there. These are the only protocols that DataStage clients use to connect with DataStage servers.

Versions 2.5, 3.1 and any higher number supports NLS, however, the choice to install NLS must be made when installing the server component. Howver, ou should not need NLS to handle Spanish characters.

It's TCP/IP if the Omit check box is cleared, and LAN Manager if the Omit check box is checked. Good luck at the interview!