I'm unable to loop in the 7th level Hierarchy in the XSD for Hierarchical stage in DataStage 11.5 Because Hierarchical stage not allowing to map the fields itself for that special Level into the output fields.
like----
<xs:element name="VCHR_DIST_STG" type="ns1:VCHR_DIST_STG" minOccurs="0" maxOccurs="unbounded"/>
<xs:element name="QBE_AP_STG_DTL" type="ns1:QBE_AP_STG_DTL" minOccurs="0" maxOccurs="unbounded"/>
Could you please any body help here ASAP.
How to Loop in 7th Level of Hierarchy in the XSD?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Wed Oct 07, 2015 4:14 am
- Location: BANGALORE
Its very difficult to appreciate what issue you are having, but this looks like these two elements will appear in your imported schema as independent "lists" (blue icon).
..this means that they would be independent lists coming in, very likely connected in some manner by a higher level node (and often, yet again a higher level "list").
Most common in such situations is that you have multiple input links coming in....one link with VCHR information and rows...and another for the QBE set of rows....and then they are joined up above before using REGROUP steps to narrow down your hierarchy and apply the repeating rows at this particular level.
It helps to build these piece-by-piece...seeing how to construct the nodes independently as you work thru the hierarchy.
Ernie
..this means that they would be independent lists coming in, very likely connected in some manner by a higher level node (and often, yet again a higher level "list").
Most common in such situations is that you have multiple input links coming in....one link with VCHR information and rows...and another for the QBE set of rows....and then they are joined up above before using REGROUP steps to narrow down your hierarchy and apply the repeating rows at this particular level.
It helps to build these piece-by-piece...seeing how to construct the nodes independently as you work thru the hierarchy.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>