DSXchange

Guys, Is there any way of collecting data from different containers local or shared into one single pool ? I dont have a join stage. But is it possible using link partitioner and link collector ? Thanks, Shiv _________________________________________________________________ The new MSN 8: smart spam...

Has anyone customized metastage reports? We need to publish ETL design info
(some fields) and last update date from process metadata? How to locate
these two and produce one report, preferable easy to understand...

Appreciate any/all help...Kamal

Hi guys- I am trying to open a GIS (Geograhic Info Sys) DBASE .dbf file. Although I am able to import the metadata with no problem (WIN 2000) into Manager w/ODBC using a system DSN, when trying to read the actual file I get the following error: ParcelsDbfTest..PARCELS_DBF: DSD.BCIConnect connecting ...

Lets take this one step at a time. A hash file is no different that a sequential file in that it has an explicit directory path location. If two jobs "see" a difference in the data, then theres usually only 2 things that can explain the difference. The first is the file location. If you are not usin...

Yes im running the reference job after the hash file creation. And im looking for every Key column. Shiv >From: bxdatta@regence.com >Reply-To: >To: >Subject: Re: Dynamic Hash file with inserts and updates >Date: Tue, 21 Jan 2003 13:37:25 -0800 > > >Make sure you are running the referring-job after t...

Make sure you are running the referring-job after the hash-building-job is over. Also, you may get strange results if you are not looking up based on all of the key columns of the hash file. P.S. Pls delete the tail, if it doesnt relate to your question. "Shivprasad Rao" cc: Subject: Dynamic Hash fi...

Hello Guys, This is an ignorant person question, Im trying to build a dynamic hash file which insert a row and update an existing column. I have disabled read and write caches. Job runs fine and in target hash stage i can see the columns being updated. But if i use the same hash file for reference l...

Perfect. This this is rocking now. Thanks Bibhu >From: bxdatta@regence.com >Reply-To: >To: >Subject: RE: Oracle Sequence and OCI >Date: Tue, 21 Jan 2003 11:04:48 -0800 > > >Table name property is in the general tab. Select generated sql and you >shall see the table name property become active (its p...

Table name property is in the general tab. Select generated sql and you shall see the table name property become active (its probably greyed out now). Fill in the value "DUAL" in it and then change the query type to user defined. Thanks, Bibhu "Shivprasad Rao" cc: Subject: RE: Oracle Sequence and OC...

Craig, There is no table name property in the OCI lookup stage for custom sql. So I am unable to specify table name for user defined sql. thnx, Shiv. >From: Craig_Hulett@rsausa.com >Reply-To: >To: >Subject: RE: Oracle Sequence and OCI >Date: Tue, 21 Jan 2003 11:19:19 -0700 > >Oh, THAT problem. Even ...

Oh, THAT problem. Even though you are using Custom Sql, you need to put *something* in the Table Name property on the OCI Lookup stage. I usually just put DUAL there for stuff like this. -craig "Shivprasad Rao" 01/21/2003 10:04 AM Please respond to datastage-users To: datastage-users@oliver.com cc: ...

David, The stage gives me the following error DSBrowser..ORAOCI9_27: Table Name is a required link property for Link DSLink1 DSBrowser..ORAOCI9_27.DSLink1: DSP.Open GCI $DSP.Open error -2. The confusing part was I dont have any link with the name DSLink1. Thank you, Shiv >From: David Barham >Reply-T...

Further, I would choose a table with a relatively small number of rows as my "other_table". Dont you wish the "dual" table in Oracle had a few more rows As per Rays efficiency suggestion, to guarantee 3 rows from "other_table" in Oracle (everyone uses Oracle dont they...): select x.a, x.b, x.c, x.d,...

Cute approach. Even more efficient would be to guarantee exactly three rows from table y (syntax for this varies with DBMS). Or a view on table x that contains exactly three rows. ----- Original Message ----- From: Chris Kearns Date: Tue, 21 Jan 2003 13:11:47 +1100 (EST) To: datastage-users@oliver.c...

Thanks Ray We are running DS4.2 on Win NT 4. Recently we have lots of problems related to hash files, Design not found, Job Number not found, RT_Config error, unable to login to project... Most of errors are happening at peak hour when lots of jobs are running. Sometimes restarting the server reduce...