DSXchange

1 and 4.

When is the interview? :D

Thanks Chullet, 8) The Information you shared was really very helpfull for me and I hope will be for others also. Yes, Your assumption is correct, My job is taking slightly more time to load the tables. The end user is Ok with the load time provided he doesnt see the red and yellow DOTS :D in the Jo...

Hello, ORA-01418 gives http://www.techonthenet.com/oracle/errors/ora01418.php in the net. Are you sure that your index exists ?? If yes i think it's an access problem. Thanks CLOPES for the prompt reply. Yes I have checked the all_indexes and dba_indexes. Additionally I get more information about t...

Keshav,

Yes you are right that I need access to do a alter on the Index. But My question is, Its making no difference if I not use this property in the job.

Is this something to do with table partioning? Forgive me if I am wrong.

Our table is not partioned I guess....

Chullet, I think the User that loads this table doesnt have access to either disable or enable Index. When I remove this Index Mode property from the stage. I no longer get this fatal error.Also If I check the status of the index, Its Valid. So should I not use this property although there are index...

Hi Gurus, I am using the Oracle enterprise stage, With load option. I am specifying the Index mode property to rebuild. I am getting the following error. I searched for the forum for this topic but it didnt help much. ORA_Aft_Cpr_Data_Tab: Oracle call failed; sqlcode = -1418; message: ORA-01418: spe...

Yes there exists a database, The Universe database. You can query it from the TCL prompt.

Andrw,

All environments are isolated and lie on different servers.

Hi guys, I just tried the folowing input: Col0|val0,Col1|Val ue1Z Here Z is the record de-limiter and comma is the value delimeter. I get the error: Sequential_File_1,0: Delimiter for field "Value" not found; input: {Col1|Val} But if I give the folowing input, it works. i.e all in the sam...

Yes, I tried with 2 Node and with single node also.... Also to add environments are isolated.

The job on 3 nodes creates 159 Process.

2 Nodes - 102 and on

1 Node - 55 Process.

Help Please

Performance reduces. I dont think so.... :shock: You are adding more joiners just beacuse they have some functionality to be implemented (I'll assume this). So if you want your job to work more than the time consumed will be more (Not Performance). If you want performance improvement try revamping ...

It doesnt matter how much lines you record is running into. What matters is where record delimiter is located. So giving the exact column and records delimiters should serve the purpose. :D Thinking outside the box.... Your monitor can display only those many characters with the current screen resol...

Forgot to mention this one.

The OS is SUN Solaris

Hi Gurus, I have a complex datastage jobs. I run it on test environment (2-Nodes). Prod Environment(4-Node) and Stage Environment(3-Node). The job runs fine on Test and Prod but always fails on Stage with a fork() error. (Not enough Space). I tried running the job in stage environment on 2 and event...