DSXchange

Hi guru's,


I ran a job, with using partition table option in Oracle stage.
My job aborted and getting this error
APT_OracleRowid8PartTable: failed to get the block count
I gave one table that table is paritioned in DB level.


Any one give the solution for this.......


Thanks in Advance,

Your souce system is Database or Flatfiles? If it is Database Query will be faster in my experience Thanks GOPIK, MY source system is Database. we are doing the performance tuning of jobs.But before 6 months back somebody tuned the jobs. They are replaced the DISTINCT clause in query by Remove Dupl...

Hi guru's,

I want small clarification,
I want to remove the duplicates.
which one give better performance either DISTINCT clause in source query or Remove duplicates stage in our job.


Thanks in advance.....

HI GURU'S, I DID SMALL MISTAKE WHILE EXPORTING THE TABLE DEFINATION. THAT MISTAKE IS I EXPORT A TABLE DEFINATIONS FROM PRODUCTION, THEN I IMPORTED INTO DEV WITHOUT CHANGING READONLY OPTION 1 TO 0. NOW THAT TABLE DEFINATION ARE NON EDITABLE. SO HOW TO CONVERT THAT PERMISSIONS TO EDITABLE. THANKS IN A...

Hi ALL,

I have a problem , while exporting the whole project from production to development.

I am getting this , 1458-read-only objects were omitted.

can any one give reason for this
Thanks in advance

Hi all,

can any one give some information on generic stage.


thanks in advance

ray.wurlod wrote:The Join stage will almost never give better "performance" (less execution time) than a homogeneous join performed in the database. There are two main reasons for this; first, the database almost cer ...

Hi Ray,
Thanks a lot for valuable information

Welcome aboard. If you are looking for a professional consultant to assist, then there IS an easy answer. Otherwise how about you begin by defining "performance" in an ETL context. Actually, before you do that, search the forum for any/many of my explanations why rows/sec is a useless met...

Hi all,

can any one help on performance tunning.

Thanks in advance