DSXchange

In short,
The table definitions are not required for the compiling and running of jobs.

Table definitions are used when you want to do metadata analysis.

Regards
Sreeni

Hi,

Chullet's observation is an apt one. Instead of deleting 90 percent of
records transactionally you can create a temp table with 10 percent records and then swap as suggested by him.

Before doing this have the ddl/dmls for FK,indexes generated from TOAD or any other pl/sql tool

Regards
Sreeni

Just to Add:

The Before SQL and AfterSQL tabs as well work with DML not DDL.

Regards
Sreeni

Hi,

Help for using the find command

find ./ -name FILENAME - to search from current directory

Regards
Sreeni

Hi ArndW

Thanks for your advice. I will try this and get back to you.

Regards
Sreeni

HI ArndW, Thanks for your inputs. I am some how not convinced of your reasoning that sorting data in a sequential file is faster than the database solution. I believe that sorting using a database solution is faster in case of millions of records rather than doing the sort in a sequential file. :? R...

HI ,

A logical solution. Hope this helps:

You can delete records older than march 2005 in batches.
For eg records older than march 2000,march 2001,march 2002,march 2003,march 2004,march 2005...so on.

This would definitely be faster than a single delete.

Regards
Sreeni

HI, You can load the data in a table and then again select the distinct records. This is costly process in terms of database resources but is beneficial if millions of records are present. The solution of performing a sort and comparing with previous value could be very slow for millions of records....

HI,

Just to inform that i tried using truncate command using parameters.
It did not work. I believe DDL commands do not work with parameters
in datastage


Regards
Sreenivasulu

HI Roy,

Out client does not want to go for a ODBC license.

I would try to find an alternate way to solve this issue.

Thanks for your suggestions.

Regards
Sreeni

Hi Ray,

I would try this.

Thanks a lot for the suggestions.

Regards
Sreeni

HI Arnd, I am using datastage server 5 and want to implement recoverability. i.e if the data has already been loaded for the current batch then truncate the target table and start loading. Therefore i want to prevent loading if the truncate feature does not work. Hence i wanted to use the Job contro...

HI , We need to connect to database(oracle) using datastage basic language. I need to use this in the job control tab in job properties i.e i need to invoke "sql plus". Is there any database connection command like ExecSH which we use to execute unix commands. Appreciate your help Regards ...

Sorry, What I mean is migration of hashfile data files from one server to another server. We migrated project but along with that hashfile (i.e., data files) will not be migrated. So how to migrate from one server to another server.

I want to know, how to migrate the Hashfiles. Can any one suggest me