DSXchange

Millions of data will obviously prolong the output. The result you get in TOAD is actually the throughput. Still you should be able to see the Process of of the rows been flowing in statistics. Check if you with sequential file as Target directly connected to the Input OCI stage. Try increasing the ...

What is the exact error message that you get?
Check your project folder if you have the directory still exist.
Use LIST UV_SCHEMA in TCL or in your Command option available in Datastage Adminstrator, to see if the project get listed out.

It'll be better if you can explain your requirement in brief. So that the method you choosed can be justified.

Hi Nima,
There is no such guide avaialble other that the pdf that are provided in your CD(client installtion pack) or the one given in your Transition class. If you dont have one, you can ask form you support provided as well.

Your lookup file stage will work expectedly if the lookup file set also got partitioned thorough hash with the same key.
Theoritically it doesn't require sort. But when you create a lookup fileset, in most case, if you notice you dump score, you can notice a tsort operator inserted automatically.

Speak to your DBA to increase the value of the PROCESSES initialization parameter.

What stops you to create a new project "GMIS_Mig" and import all the project in it?

Hi Varun,
Welcome aboard!!! :D
'Reset if Requried and Rerun" option should reset before executing the job.
You may find it aborted after the run, and that may be due to the current run. Do you get any error message or warning for this reason?

How do you load data. In most of the database, the load will be optionally logged. You can collect it in a file as well.

So its like, one job will run every day and other job once in 45days. If so, schedule one job daily, and convert the data into integer either julian or days since option. And find MOD of 45 (Mod(date,45)+xdays for correction). Check for 0 and trigger the other job job. Or maintain an external file o...

For all those changes that you wish in this Forum, you can log under Site/Forum.

Whats all the parameter that been passed?

If its problem in repository inconsistency, I would not expect in two servers at the same time. First option try to DS.REINDEX ALL from your adminstrator Command option. Make sure all your client session for that project is terminated before performing this one. Just cross check that you are not in ...

I dont guess,it will be a first time error after 11 months.
Still you got one solution for this.

tagnihotri wrote:Ray, I am preety sure expert like you must be having answer to this also

Like Wiki