DSXchange

There are some databases where you can partition on the source (Oracle, DB2...), but the advantage of PX lies in the transformation stage. PX is capable of breaking up the data into good set of partitions (as defined by your $APT_CONFIG_FILE), and handle each set individually. This is why we strong...

For a parallel job, even if the job is reading or writting to a NON-partitioned Oracle table, does the job still need to access the the following Oracle system tables? DBA_EXTENTS DBA_DATA_FILES DBA_TAB_PARTITONS DBA_OBJECTS In other words, regardless what type of Oracle table is accessed, the selec...