DSXchange

what are transaction logs , why are they full?

any answers greatly appreciated.

Thank you Sainath for ur answer.

Thank you very much for ur answer Ketfos ,

but can you tell me what are transactions logs , where are those located.

thank you ,

Thank you very much Ketfos.

yes , when i delete commit needs to be issued , but when i do the truncate the table i need not issue the commit after it , still the transaction is done . but i want to know what are transaction logs , why are those getting full when delete command is issued. Thank you all. Thank you, [size=9][/siz...

Hi , " looks to me that datastage is deleting records from the database and not truncating the table,hence your transaction logs are getting full. Try trucating the table before you run the job. " deleting the records does not mean truncating the tabel , if what are transaction logs where ...

Hi All,

What does Transaction level and Array size indicate , and how do they effect the job?

Thank you all,

I know oracle bulk loader just does inserts , what i want to know is there
any performance issue when we insert data thru normal OCI AND
thru bulk loader if so why?

Thank you very much for all ur answers.

Thank you very much Ray.

Hi all,

Can any one shed me some light on what is NLS , what is its purpose and what are its settings? Is system date format or any thing else set there.


Thank you all.

Thank you all for the answers,

but can any one clear me , what would be the difference between , the oracle bulk loader and normal inserts thru OCI STAGE.


Any answers would be appreciated.

Hi Bland ,

Thank you all for the answers, but Bland you mean to say updates are
slow normally it tool doesnot matter , only it depends on the database.

Can you clarify me.

Thank you

how are updates in 7.5 version on an oracle table , for 300 thousand rows,
is it good way to choose datastage or is it better to user oracle plsql ,

we are preferring to use datastage what do you say.

Can any one help with suggestions

thank you very much Roy.

How do i check the log of the checker utility , which is mentioned that it would be under the project directory.

Thank you Ray for ur answers.

Thank you all for the answers.

can you tell the document which would clear me some these stuff.

Thanks once again.