partition techniques in datastage

hofheimer March 08, 2022 datastage , partition , techniques Comment

Rather than group similar data there are times when it is desirable to distribute data such that it does not correspond to a business or a logical view of the data as it does in range partitioning. Virtual Column-based Partitioning.

Partitioning Technique In Datastage

Still the significant difference between both is Informatica forces you to organize in a step-by-step process.

. This is possible by the virtual column-based partitioning method which creates logical partition keys using the columns of the data table. Differentiate Informatica and Datastage. There are times when it is not obvious in which partition data should reside although the partitioning key can be identified.

In contrast Datastage provides flexibility in dragging and dropping objects based on logic flow. Both Informatica and Datastage are powerful ETL tools. The partition of a database is possible even when the partition keys are physically unavailable.

Datastage Partitioning Youtube