DSXchange

After date_from_string() and time_from_string() in one Modify stage you will need a second Modify stage to apply timestamp_from_date(). Two adjacent Modify stages are not permitted so you will need a Copy stage between them.

Have you given any thought to lineage analysis in all of this? That is, when an end user asks "where did this come from?" will you be able to supply an answer if all the schemas are being created dynamically? It is for this reason I try to avoid RCP.

After the excitement of 06-06-06 (fireworks, dancing in the streets, Mexican waves) one is surprised no one noticed that last Thursday was one of the few Pythagorean dates this century (10 AUG 06, that's 10 squared = 8 squared plus 6 squared). According to calculations, future Pythagorean dates incl...

Neat. I already have a use for that.
:D

The Sequential File stage, when asked to read multiple files with identical schema, actually generates a File Set control file to manage the same. You can see this by dumping the score.

Think about it. Say it.

But don't do it, at least not in my pool.

Curious, since there's a warning explicitly against setting the code page for the MetaStage repository to UTF-8 - at least when creating same on Oracle. Just an observation.

It won't help to say it oughtn't to happen. Are you SURE there is no constraint or other obstacle to the write? How many rows does the job indicate were sent to the hashed file? How many actually made it? Can you reproduce it with a different hashed file? How was the hashed file created? I've just c...

Not entirely. Bumped into it quite a while back, when doing some work with Focus. It's a database (and more - read their marketing hype) from CCA. You can get at it using ODBC or JDBC.

100,000 is not really a lot of reference records if the record size is small. If that set of data will fit in physical memory your approach is fine. The data are streamed in from SAP into a virtual Data Set, and it is against this that the lookup is performed. This does not require sorted data. If y...

If you read in the Parallel Job Developer's Guide about surrogate key management you will get some ideas. You need, perhaps, to allocate separate ranges of serial numbers that can be used by each instance, or work through a single-threaded process (such as the key management routines) to be able to ...

That is not a DataStage server issue. DataStage is merely logging what Netezza sent to it. You have to figure out why that happened. Overload?

MASTER OFF ALL is user processes (connected clients, running jobs using DataStage repository facilities). The services are the DataStage resource, telnet and RPC services. Not the same at all. I trust you wait for a decent interval between MASTER OFF ALL and shutting down services, as well as making...

prabu wrote:Could someone please point to me the document which lists the datastage background processes [URL or document reference].

i know ps command will give me an overview

thanks,
prabu

It is not officially documented anywhere.

Surely ORACLE_HOME always drives where tnsnames.ora is sought?