DSXchange

This is what i found in the log: Asset.Transform: DSD.StageRun Active stage finishing. 85277 rows read from ASSETLOAD 85277 rows read from SPRODINT 85277 rows read from INVOICEADDRESS 85277 rows read from INSTALATIONADDRESS 85277 rows read from ORGANIZATION 85277 rows read from CONTACT 1602 rows wri...

Bert, What row count do you see on the output links in the job/jobs? Peter K ----- Original Message ----- From: To: Sent: Tuesday, July 01, 2003 6:04 PM Subject: Do not receive all records. > > I have a data stage job reading from 6 files and generating 1 output file. > The job reads some 85000 reco...

I have a data stage job reading from 6 files and generating 1 output file. The job reads some 85000 records (I can see this in the log) buth only write 1602 records to my flat file. When I run the job, theres no limit on the number of records or ont he number warnings. Ive checked all files and ther...

Dear All, I would like to have information on ETL Server maintenance required on a regular basis. With regards, Binu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting...

You must always delete projects using the DataStage Administrator client. This not only deletes the project, it also drops the schema (entries in the system tables UV_SCHEMA, UV_TABLES, UV_COLUMNS and so on) and also removes the entry in the UV.ACCOUNT table in the Engine account. Now that youve del...

Dear all, I have a project which contains many of junk jobs so I intend to delete it and create it back in the same name (called "proj1"). The below is the error message when I add a new project via DS Administrator. DSR.ADMIN: A schema called proj1 already exists. This must be dropped before the pr...

Do you use OCI stage as lookups? If so, just replace it with ODBC stage, it should work fine. xiong -----Original Message----- From: Kalton, Joel [mailto:Joel.Kalton@cignabehavioral.com] Sent: Saturday, 28 June, 2003 03:53 To: datastage-users@oliver.com Subject: Abnormal Termination of Stage Resolve...

I think your best bet is to enrol in "DataStage Best Practices" in which they cover how to implement the three most common types of slowly changing dimension in DataStage. There are effects not only on the dimension tables themselves but also on subsequent loading of the fact table(s) that have fore...

Hello All, I noticed some inconsistency while updating my target table from a staging table which has one record for every transaction happening to a single record in the online system. My staging table does not have any primary key. While loading my target table I order the records on ROWID so I ge...

This is a topic for an orphaned message.

Problem resolved. Unidata logging was pointing to a directory off of /tmp. This directory was wiped out during the reboot. --------------------------------------------------------------- Hello - We recently rebooted our DataStage server and restarted DataStage and our first job keeps aborting with t...

Joel Have tried recompiling? If that does not work then rename it and import it from a backup. Some of the files could be corrupted. If this job was running or someone was in Designer when you rebooted then you could of corrupted the files associated with this job. Thanks Kim. Kim Duke DwNav - Navig...

Hello - We recently rebooted our DataStage server and restarted DataStage and our first job keeps aborting with the following error: Abnormal termination of stage DailyDDWSitesDelete..Trans1 detected This is all the information there is. We are on Solaris 8 DataStage version 5.1 r1. Other jobs work ...

Alan has confused the BUILD.INDEX syntax with that of RESIZE. The USING clause with CREATE.INDEX allows a different file dictionary to be used. You can create an index in a separate DataStage project (account) using the AT keyword. But it does have to be another account; it cant be in just any direc...

Mario, You may also specify the directory CREATE.INDEX uses for the temporary files by adding USING [full directory path] to the command line. Try HELP CREATE.INDEX for exact syntax. Alan > > From: "Ray Wurlod" > Date: 2003/06/26 Thu PM 06:49:52 EDT > To: datastage-users@oliver.com > Subject: RE: BU...