Thanks guys.
While inserting into fact table, do we drop the indexes and remove any relationships between dimensions and fact for better performance?
Search found 7 matches
- Wed Oct 06, 2010 11:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Steps to take Fact load
- Replies: 4
- Views: 2096
- Wed Oct 06, 2010 5:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Steps to take Fact load
- Replies: 4
- Views: 2096
Steps to take Fact load
Can anyone guide me the steps to take to load fact table. Performance should be good and data load should be error free. AND Suppose i want to load 100million records and Job failed after 50 million records.Is there any way to load the rest of the rows(Remaining 50 million) instead of all from scrat...
- Tue Oct 05, 2010 11:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Node Pool & Resource Constraint
- Replies: 3
- Views: 4911
- Tue Oct 05, 2010 3:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row comma separated values
- Replies: 29
- Views: 25869
- Tue Oct 05, 2010 12:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Node Pool & Resource Constraint
- Replies: 3
- Views: 4911
Node Pool & Resource Constraint
Hi,
Can any one give some idea about Node pool and Resource Constraint and where it is useful.
Can any one give some idea about Node pool and Resource Constraint and where it is useful.
- Mon Sep 27, 2010 3:32 am
- Forum: General
- Topic: Sequencers
- Replies: 3
- Views: 2160
- Fri Sep 24, 2010 2:43 am
- Forum: General
- Topic: Sequencers
- Replies: 3
- Views: 2160
Sequencers
Hi,
Could any one suggest me like where the information regarding Sequencers is provided.
I worked in Autosys but very much interested to learn Sequencers.
Could any one suggest me like where the information regarding Sequencers is provided.
I worked in Autosys but very much interested to learn Sequencers.