Staging recursive hierarchies in 2012

Question

Hi all,

I have a short question which I hope someone will be able to help me with.

In MDS 2008R2 it is possible to create a recursive parent child hierarchy (ParentCode attribute in the entity is a domain based attribute refering to it's "own" entity).  It is possible to stage such an entity all at once in this version!

Now, in MDS 2012 i wish to do the same thing, using the new way of staging - using the <entity>_Leaf staging tables.  In this scenario i get error 210003 for all records, except for the root (having ParentCode set to NULL).

Do I really have to do this "operation" in two steps under the new staging model?

1) Stage all records in the entity without the ParentCode

2) Update all records in the entity with the ParentCode

To answer some initial questions

1. I am sure that my ParentCodes matches Code values

2. I use ImportType 0

Thanks in advance!

Answer 1

That is how we import our parent-child hierarchies in MDS 2012.  We first import our parents, then take a second pass and import the children. 

Answer 2

Hi BI Baracus,

Allright!  Seems that is the way to do it.

Thanks!