DSXchange

Hi Ogmios, but what you describe is a 'repeatable read' and this is an 'option' with other databases, you get to choose if you want to see updates that are committed after the start of the query......are you saying with Oracle this is not an 'option' but how it works all the time?...... Also, I thou...

Refer to the DataStage Disk Caching Guide in your online documentation. Hi Chuck, this is the document my DS guy quotes as saying that a hash file cannot be shared across different jobs only different instances of the same job... I'm really hoping he has misread. I'm hoping to hear from someone how...

We are in a phase of considering in conversion of our existing database Redbrick to DB2. I would be interested if anyone had changed the database from Redbrick to DB2 and also changed the datastage jobs. Is there any way we can speed up the process of converting jobs which handles from redbrick to ...

Venkat, "You mentioned not to rely on the LASTUPDTTM time stamp, is there any specific reason?" I think we discussed this about may last year on this forum.....The problem is that in Oracle (bless it's little cotton socks) the last update timestamp is the time that the row was updated by o...

srikie wrote:If there any more questions regarding this I hope you guys will help in the similar way.
Thanks
srikie

As much as we can Srikie, given a 168 hour week.....

we generated a million rows of data and tried to load on a small AIX server in our office here. Same result, 1,400 rows per second even when loaded directly via oracle loader.... When you say 'loaded directly via Oracle loader', you mean sqlldr and not the Ora Bulk stage in automatic mode, yes? And...

What should I know about the implications of sharing hash files between jobs. I plan to have many jobs running simultaneously all doing lookups and writes to the same hash file. Thanks Hi HSBCdev, I would be interested to see how you go..... I believed that it was possible to share one hash file ac...

Ray, indeed. I like it that DataStage is integrated as much as possible. But it doesn't have a scheduler/monitor that answers to some requirements, as the one that was discussed higher in this topic. Would it be a priority for Ascential to ad more functionality (like this one) into the scheduler? H...

Hi! How can I update few rows in no character format(ex. integer or numeric) in Sybase IQ 12.5 database using DataStage?? When I'm trying to do this , there is an error both in OC and ODBC. theese drivers can't convert character to decimal or integer type and DataStage always treats all formats (nu...

Hi Guys, next step in our diagnosis.....we generated a million rows of data and tried to load on a small AIX server in our office here. Same result, 1,400 rows per second even when loaded directly via oracle loader.... We took the same 1M rows and loaded them on a 2 CPU PC we have running win2003 an...

I seriously doubt that the MetaBroker for Informatica has the ability to grab design-time information. No other MetaBroker does. They concentrate on technical metadata (table definitions, etc.) and process metadata. Hi Ray, I think MetaStage had an interface to grab run time information from standa...

Sainath.Srinivasan wrote:You can transfer the metadata across using the MetaStage (I believe MetaStage metabroker is available for Informatica)

Hi Sainath,
I believe you can, and I think it might even be possible to transfer run time stats through CDIS 1.0 (I think it was called)...but this does not 'buy' one much....

Hi peternolan9 , Even I thought so. But there should still be the way to atleast put the checkpoints cause it is the most important thing in whatever datastage version you are working for. I am not very particular about mvs I just want to know if it has it or not. Cause I think if there is any faci...

Hi I know that Import\Export facility is there both in Informatica and DataStage. Is it possible to transfer a job from Informatica To DataStage using them :? :?: I want to mean I m exporting a job from Informatica and now I want to import it to DataStage. Is it possible? :!: Billu Billu, I have wo...

Hi, We are planning to migrate 100+ tables in incremental mode. Out of which 25 of them are Fact and Rest of them are dimension tables. I am trying to come up with optimal mechanisam to produce Surrogate Key. Is there any out of the box solution available from Ascential (like Oracle Sequences ) or ...