Is there any way to update a dimension with a mapping in 12, or do you have to recreate it each time?
Barney - a mapping recreates the dimension. You can modify a dimension with App Engine but be careful of conflicts if you then run the mapping again. so the two should use the same table and an AE process could do changes like adding a new element to an existing parent from the shared table.
Thanks John. I'm going to resort to updating the relational table instead I guess.
More precisely, a mapping recreates a single hierarchy. Isn't that correct? SO if a mapping exists for a single hierarchy, the other hierarchies could remain untouched.
The application I am thinking of is where a company has hierarchies created by hand in addition to the hierarchies imported from the source system. The hand made hierarchies would survive the import if they were in separate named hierarchies.
BarneyYes if in separate hierarchies (as distinct from parallel hierarchies).
