DSXchange

I tried orchadmin delete test.lfs. It worked.
However you cannot look at the data using orchadmin dump. Same way cant use dsrecords to get count.

Create a time dimension table upfront and load values from 1900 to 2100 or whatever range you want. For daily data take date (20050228 ) and join to the time dimension table to get quarter ,month week , or any info you want.

Put the data from DB2 and Oracle into two datasets. Then do a join.

Bram
The / may pose a problem in unix filenames Do you want date as mm/dd/yy ?? Or is mm-dd-yyyy is fine??

bgs Take a look at the following post http://www.dsxchange.com/viewtopic.php?t=91256& You have to have a unique index or a primary key constraint over the 'key' fields so that Oracle (and DataStage) has a clue that the record is either new or a duplicate. My guess is you don't. It will only perf...

Is 16300 records your test data?? What is your expected live production volume?? You should not come to a conclusion based on your results from such low volume. IS there a critical 20 second window?

hgs
I am thinking insert is done first. If insert is unsuccessful then update takes place.

Check your job control section. I think there is a mistake in your BASIC code.

Can you post what you have in your job control page??

Try to identify which stage produces this error. What stage did you add/modify recently?? Are you calling any external programs in any of your stages. IF this error popped up in a previously running job contact Ascential.
Thanks

Neal
Do you have an estimate of update to insert ratio?? If it is small try splitting into two streams (Update and insert). How wide is your table??

Try to monitor other DB2 activities and other resources.
Thanks

I mean plugin metadata definitions. Sorry

After clcking columns, when you click on Load, if you do not see your table definitions, you can click on import and choose builtin metadata definitions.

Aparna Your query looks incomplete. I guess you missed to post a few lines for the last table #pUKDWSCHEMA#.DWH_DS_CNTL_RUN AS A7 There is no joining clause. Can you post a few rows from your View Data windwo?? Post the ones that are wrong. Did you run the job or you just viewed the data. As suggest...

Hello Shared containers ( as compared to writing to datasets and using those datasets to continue processing) perform better because of pipeline parallelism. On the other hand it is always recommended not to build big jobs . ( Build smaller jobs becuase of restartability and manageability and other ...

The link really worked.
http://ascential.com/eservice/pages/pro ... trate.html

I was always thinking Ascential kept the documents secure and made it available only to buyers.

May be I was wrong.