DSXchange

It's usually the Data folder in your Project that these files are written. I would have to check whether the Rules Analyzer uses this folder, however, and my current site isn't using QS. Anyone else? The files that Rules Analyzer uses for testing are stored in the RULES folder where your QS client ...

Ray I was talking more along the lines of the problems I have encounted with ProfileStage. Stuff like getting an error trying to view the sample data. Data sample creation in progress error when trying to run table analysis after the column analysis has finished days ago. Other generic errors when t...

Just thought I would share my thoughts with the forum. Is it just me or do other people think that the ProfileStage product isn't as polished as some of the other products in the Ascential range? I have been using QualityStage and ProfileStage for the last few weeks and it seems to me that ProfileSt...

I get the same error trying to do a table analysis on a oracle table that has 800K rows. Support has said that the error 88 occurs due to a message timeout. Was asked to changed a setting in the MGMPgmInit.int file to 300. Didn't fixed the problem and still working on a solution for a fix. Table ana...

I have done column analysis on a table and when i veiw the results I attempt to view sample data i get the following error. Failed to Populate sample data. Under Connection Manager for the given source I have set up the browse option for the source, and the only option I have is to use the Reposito...

I agree with your reponse. I just walked into this account today and was told that was the reason for landing the data in the job. I will post some more information once I dig a bit deeper. leslie Might have something to do with database record locks if you are reading and updating the same record ...

vinaymanchinila wrote:I am using the Transformer and writing to 18 Flat files, the issue is how do I clear this file everytime it runs, as all the 18 links are append !

Are you writing the data to 18 different flat files or the same one?

Vincent & Ray,

How do you see the Australian Datastage job market going over the next couple of years? Up or down?

Tim

yaminids wrote:Hello friends,

Can anybody tell me how to delete hash files?

Thanks a lot in advance
Yamini

DELETE.FILE filename through Datastage Administrator will delete the hash file.

There are other posts on deleting hash files that you can find if you search for them.

Tim

Through Oracle front-end Tool(Quest Central or Toad) you can trace session and see which user ? , what query is running ? and how many resources are consumed for running a query?. Well I had tested it in my case it was killed. But wanted to know from people out here on forum, if they came across su...

If a huge SQL query is submitted in the ODBC stage and the job is reset/stopped, is the query killed or does it keep running on the DB. If yes, what is the solution? Recompile the job? I have found that most of the time on an oracle server that yes the query is still running. Contact your DBA to ki...

the job is able to write the data into seq file... What Sainath was saying is that your job might be doing alot of look ups and trying to write or update to the same database table. Instead of doing the insert and updates into the database in the same job, put the records that you want to insert or...

Hi all, I noticed that the folder &PH& is growthing very fast. now the size is reach 1 GB. When I check the creation date, a lots of files are few months old. I curious whether can remove the files inside the &PH& when no phantom jobs are running. Yfng, Yes you can remove the files ...

Tim, KeyMgtGetNextValue is an 'sdk' routine supplied with DataStage by Ascential. It reads a record from a specific hash file in the current project, gets the requested record (which holds a numeric value) increments it and writes it back to the hash. It's basically a methodology to generate surrog...

(6) In INSERT, I have am using "KeyMgtGetNextValue("ProductID") and getting ProductCode, Name from CSV. Even though I am getting the next value using the KeyMgtGetNextValue why it is pulling diferent values like 1,5,6,7? Since the Product Table already has 51 rows (ID from 1-51), thi...