i have a xml structure as attached...
My req is to store the replicant number as the primary/foreign keys to the database. I read the "deploying replicants" section in dd_admin pdf and got this far... by creating the below dbschema... The pdf says us to use value-from-field="not-used" in order to get replicant order.
The problem i am facing currently is in the second non-root table - P2_STAGING. I want to create two cloumns to reference the two replicants - parent and child but don't know how... how to specify that this column (eg
1_KEY and P2_KEY) to reference this replicant?
With the below files in place if i create an DCR like...
.....................rt/0/tag_line/0=testtagline
.....................rt/0/p1/0/pb1/0=pppp
.....................rt/0/p1/0/p2/0/pb2/0=oooo
.....................rt/0/p1/0/p2/1/pb2/0=uuuu
.....................rt/0/p1/1/pb1/0=xxxx
.....................rt/0/p1/1/p2/0/pb2/0=yyyy
.....................rt/0/p1/1/p2/1/pb2/0=zzzz
...then the data stored in the database are
1. CM_TESTDCT__TEST_STAGING
.....................testdcr testtagline
2. P1_STAGING table
.....................testdcr 1 pppp
.....................testdcr 2 xxxx
3. P2_STAGING table
.....................testdcr 1 1 oooo
.....................testdcr 1 2 uuuu
.....................testdcr 1 3 yyyy
.....................testdcr 1 4 zzzz
basically i want the output of the P2_STAGING table to be like below which is the expected one
.....................testdcr 1 1 oooo
.....................testdcr 1 2 uuuu
.....................testdcr 2 1 yyyy
.....................testdcr 2 2 zzzz
Please help...
