nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Deployment of multilevel container

vikasp

Hi Friends,
I am having a DCT which has 4 level of containers within root container.
I want to deploy the DCR to the oracle database.In my DDconfig file i have created separate group for each level(L1,L2,L3,L4) of container.
When i create DCR using all the container(L1,L2,L3,L4) then deployment completes successfully.
If i don't use all the container(L1,L2,L3,L4) in my DCR then deployment fails.
But In my use case some DCR will use up to only L1 container,some DCR will use up to only L2 container & some DCR will use up to only L3 container.
Can anybody please explain me how to sort this out.
I am attaching my DDconfig file.
Environment:
TS672SP2, OD621, Oracle11 on solaris
[HTML]

[/HTML]

Find more posts tagged with

Comments

jagadesh

Can you try like the attachment. I altered foriegn keys and primary key .
I added like that. L4 depends on L3, L2 and L1 as foriegn key. L3 depends on L2 and L1 as forien key. The same continues. If L2 not present it wont go to deploy L3 and L4.

i hope it will works for you. try the attached one. Then again do modification on primary key if needs. Dont change foriegn key

merry

Can you try like the attachment. I altered foriegn keys and primary key .
I added like that. L4 depends on L3, L2 and L1 as foriegn key. L3 depends on L2 and L1 as forien key. The same continues. If L2 not present it wont go to deploy L3 and L4.

i hope it will works for you. try the attached one. Then again do modification on primary key if needs. Dont change foriegn key

Thanks for ur reply...
But in my table "dm_category" only id column is present & in that column i am deploying id of each category from different group.
As per ur code group4_id, group3_id,group2_id & group1_id are the primary keys.
But i am deploying to the single table and with only one PK(id).

vikasp

Can you try like the attachment. I altered foriegn keys and primary key .
I added like that. L4 depends on L3, L2 and L1 as foriegn key. L3 depends on L2 and L1 as forien key. The same continues. If L2 not present it wont go to deploy L3 and L4.

i hope it will works for you. try the attached one. Then again do modification on primary key if needs. Dont change foriegn key

Thanks Jagan,
As mention by merry in my table "dm_category" only id column is present & in that column i am deploying id of each category from different group.
As per ur code group4_id, group3_id,group2_id & group1_id are the primary keys.
But i am deploying to the single table and with only one PK(id).
Pointers will be highly appreciated Smiley Happy

Thanks,
Vikas

GroupingData.zip

jagadesh

Sorry I thought as different Table. Then lets think about your scenario.

vikasp

Does Anyone experience this kind of scenario ?? Smiley Happy

Thanks in Advance,
Vikas

crosstab.rptdesign

crosstab.txt