DSXchange

Not "import", but you can Save the table definition back into the Repository. Go to the Columns tab; you will find Save and Load buttons in the lower right hand corner.

Good management is best.

Be aware of scheduled downtime, and avoid starting any job that, based on its history, will not complete before that time.

Invest in high-availability hardware and database, so that there is no unscheduled downtime.

The PeopleSoft PACK is a number of DataStage jobs, routines and table definitions that you purchase from PeopleSoft.

Er... the Windows version beat the IBM version by three months.

Surely, if the date is in the form 21-APR-07, you would not select "%yyyy-%mm-%dd" as the date format picture!

Try "%dd-%mmm-%yy" as the date format picture string in the StringToDate() function.

Automatic means that sqlldr is kicked off straight away. Manual means that sqlldr is not kicked off straight away. This can be useful where, for example, your time windows for extraction and loading do not coincide. You can still completely preserve control within DataStage - use an Execute Command ...

Why ever not? Data cleansing is a large part of ETL. Even if you want to store "junk" data, there are no restrictions on what you can store in VarChar columns. So maybe a rethink of the target tables' data types may be in order? Take a look at QualityStage - it is particularly good at extracting bur...

Almost certainly you need a patch to address the inability to open Job activity in job sequence, and my guess is the XPSP2 patch. Contact your support provider. Your second question is irrelevant. The links in a job sequence indicate dependency. In your (a) job every activity is dependent upon all p...

Might your data contain any special characters, such as EOT (end of transmission), EOF (end of file), etc., that might cause the connection to be interrupted?

Don't load junk data?

Gosh.

Obeying the syntax rules.

Whatever will they think of next?!!

There are various rules in Oracle about what you can and cannot do with bulk loading. For example, parallel bulk loading is prohibited if the table has any bitmap indexes. A primary key index is more likely to be a B-tree, so you need to provide a value to a property in the Oracle Enterprise stage t...

Hop in your time machine and get a job with VMARK Software, starting in approximately 1995. That would definitely be the best way.

I dont see any entries for the DSN "castle".

pat_raman2000 wrote:The part which populates hash file doesn't have transformer.The oci stage is directly connected to hash file.

I want you to put one in, as an aid to diagnosis.

With two links we get separate counts of rows selected from Oracle table and rows sent to hashed file.