Hierarchy stage XML

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sainath
Premium Member
Premium Member
Posts: 138
Joined: Fri Nov 19, 2004 3:57 pm

Hierarchy stage XML

Post by sainath »

Hi
1) I want to omit null tags inside the xml group
I made column nullable and selected omit null tag option inside inside hierarchy stage. But I still see null tags. Please let me know how to fix this issue.
2) is there any may to remove duplicates in XML file before generating.


Thks
sainath
Premium Member
Premium Member
Posts: 138
Joined: Fri Nov 19, 2004 3:57 pm

Post by sainath »

Hi

In following example the POLICY_CLAUSE_TYPE_CODE/> is in xml group which is repeated many times with null values because other xml group has distinct values.can you please let me know where in the stage to specify that so that the xml tags not repeated with same data.

Code: Select all

-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>

</PolicyClausesDetails>

-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>
</PolicyClausesDetails>

-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>
</PolicyClausesDetails>

-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>
</PolicyClausesDetails>

-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>
</PolicyClausesDetails>
Post Reply