DSXchange

Yes you can. Use Business object metabroker. If you are importing and exporting (Publish and subscribe) to create your universes, you will need BO client installed on your machine. Pavan -----Original Message----- From: Rui Soares [mailto:rui.soares@novabase.pt] Sent: 24 July 2002 2:00 PM To: Datast...

Hi: We are using Datastage 4.01. We have a process that reads records from a Universe table through the FTP stage and writes it to a flat file. This process, on occasion, seems to be hosing the Universe database. The only reason I can think of why this is happening would be that a user has a lock on...

Does anybody know which driver is required for InfmxCLI plug-in? I am on DS 4.0 (Solaris box).

Thank you,
Leonid

yes, Youll just need the business Objects metabroker for metastage... regards Andrew -----Original Message----- From: Rui Soares [mailto:rui.soares@novabase.pt] Sent: 24 July 2002 2:00 PM To: Datastage-Users (E-mail) Subject: Metadata question Hi, Its possible to import Metadata from Business Object...

Hi, Its possible to import Metadata from Business Objects ( BO ), and export metadata from Metastage to BO ? best regards Rui Soares > Rui Soares > NOVABASE - Data Quality - QP > Mail : Rui.Soares@Novabase.PT > Tel (NB) : 351 21 383 65 92 > Tlm : 351 96 347 08 40 >

Hi all, What is the permission, that one user must be to cretged and removed projects ? Why we cant made this actions with other user, than uvadm/dsadm ? best regars Rui Soares > Rui Soares > NOVABASE - Data Quality - QP > Mail : Rui.Soares@Novabase.PT > Tel (NB) : 351 21 383 65 92 > Tlm : 351 96 34...

Hash files are not like tables. The records are written away with a specific physical structure. Therefore if one job writes a record with a particular key, but you reference the hashed file using a different column as the key then you are bound to get strange results. Also a Hash File can have mult...

> Hi all, > > I have a job that reads from a flat file and writes to an Oracle > table via an OCI7 stage. I run this job for several different flat files. > For one flat file I got an error reported in the log file as Oracle invalid cursor without any other more meaningfull message in the log. > The...

As with any job with a Sequential stage, the first thing thats going to happen when the job starts is the sequential file will be created if it doesnt exist. Im curious why this is a problem? For example, if you are checking for the presence of the file to determine if any rows were rejected, have y...

DataStage 5.2r1 on HP-UX I have 2 output links in a transformer : - one inserting input data in an Oracle table, - one catching the rejected rows in a sequential file - a constraint is put on this link : Ins_T_InputCust.REJECTED, and the RejectRow checkbox is checked My problem is that a reject file...

Are your sample jobs of the format: Job 1: Source -> Transform -> ORABULK Job 2: Source -> Transform -> Sequential If so, the only thing I can think of is that there was something else running on your DS server at the same time or perhaps there was a bottleneck retrieving data from your source when ...

When I created a Orabulk file, the job runs at 360 records per second. But when I create with sequential file, it creats with 160 records per second. I would like to know any tuning parameters you used for sequential stage. Karthik -----Original Message----- From: Galemmo,Nicholas,GLENDALE,IS [mailt...

A hash file can only have one key. If you need a hash of the same data using different keys you need to create additional hash files. To save time, have a job that reads the data source once and builds the hash files you need. -----Original Message----- From: Kandamuri, Karthik [mailto:Karthik.Kanda...

Hello All,

I created a hash with SSN as the key.

I used this hash file in a job and completed it. In the second job on the same hash file, if I change the key to another key, other data disappears. Do I need to create a new hash file for second job ?

Any suggestions are welcome

Karthik

If that is an issue, you can always use the bulk stage once in testing to get the script then switch to a sequential stage... it saves a bit of typing -----Original Message----- From: Chris Kearns [mailto:chrisk@zing.com.au] Sent: Monday, July 22, 2002 1:48 AM To: datastage-users@oliver.com Subject:...