文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >使用Informatica解析XML

问使用Informatica解析XML
EN

Stack Overflow用户
提问于 2020-08-26 23:02:21
回答 1查看 757关注 0票数 0

在使用Informatica解析XML文件时，我面临一个问题。XML有多个节点。示例如下。我必须使用36 SORTER和JOINERS，对XML中的每个节点都使用SORTERS和JOINERS。很明显，地图变得太大了。我使用了在Informatica中生成的内部主键和外键，使用了JOIN条件。但是，当我运行包时，包会填充缓存。有时我犯的错误是

代码语言：javascript
复制
SORT_40406 In transformation [SrtJoiner19], an error has occurred [I/O error occured writing "C:\PROGRA~1\INFORM~1\apps\Data_Integration_Server\data\temp\PMSORT1240837099_119_0a07716": 21207359488]

有时错误会是

代码语言：javascript
复制
CMN_1098 ERROR : Cache Directory may not exist or insufficient privilege/space in the supplied cache directory. CMN_1098 [Joiner]

示例XML

代码语言：javascript
复制
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Root>
  <dataModel>
    <repo name="SKU" profile="SKU"/>
  </dataModel>
  <SKU repo="SKU">
    <SKU_SKU_Number>ABCDEFG</SKU_SKU_Number>
    <SKU_Advanced_Feature_1 mLang="1">
      <value lang="en">SKU_Advanced_Feature1</value>
      <value lang="da-DK">SKU_Advanced_Feature2</value>
      <value lang="mal">SKU_Advanced_Feature3</value>
    </SKU_Advanced_Feature_1>
    <SKU_Advanced_Feature_2 mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_Advanced_Feature_2>
    <SKU_Advanced_Feature_3 mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_Advanced_Feature_3>
    <SKU_Advanced_Feature_4 mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_Advanced_Feature_4>
    <SKU_Advanced_Feature_5 mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_Advanced_Feature_5>
    <SKU_Application mLang="1">
      <value lang="en">Dehumidification and Internal Air Circulation</value>
      <value lang="da-DK">Testing SKU Application</value>
    </SKU_Application>
    <SKU_Approvals_and_Standards mLang="1">
      <value lang="en">ETL listed, UL474</value>
      <value lang="da-DK"/>
    </SKU_Approvals_and_Standards>
    <SKU_Approvals_and_Standards mLang="1">
      <value lang="en">CSA 22.2 No. 92</value>
      <value lang="da-DK"/>
    </SKU_Approvals_and_Standards>
    <SKU_Basic_Feature_1 mLang="1">
      <value lang="en">&lt;p&gt;Goodbye Humidity. Hello Comfort.&lt;/p&gt;&lt;p&gt;The Honeywell Home  TrueDRY™ DR90 Whole Home Dehumidifier  can remove up to 90 pints of moisture per day from your home's air, making you more comfortable. It's ideal for larger homes up to 3, 6000 square feet. It can remove moisture evenly throughout the entire home.&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;</value>
      <value lang="da-DK"> </value>
    </SKU_Basic_Feature_1>
    <SKU_Basic_Feature_2 mLang="1">
      <value lang="en">&lt;p&gt;Help Lower Energy Costs&lt;/p&gt;&lt;p&gt;With up to 90 pints of moisture leaving your home, you can run your air conditioner  less frequently. This means you can potentially save money on your energy bill. Less moisture in the home also helps to reduce the strain on your air conditioner.&lt;br&gt;&lt;/p&gt;</value>
      <value lang="da-DK"> </value>
    </SKU_Basic_Feature_2>
    <SKU_Basic_Feature_3 mLang="1">
      <value lang="en">&lt;p&gt;Minimal Maintenance&lt;/p&gt;&lt;p&gt;The moisture the Honeywell Home TrueDRY DR90 Whole Home Dehumidifier pulls from your home automatically drains, so you don't have to empty the water reservoir by hand. And the filter only need replacing once per year. This  dehumidifier provides unobtrusive, quiet and efficient operation. G82&lt;/p&gt;</value>
      <value lang="da-DK"> </value>
    </SKU_Basic_Feature_3>
    <SKU_Brand>Honeywell Home</SKU_Brand>
    <SKU_Brand_description code="Honeywell Home">Honeywell Home</SKU_Brand_description>
    <SKU_Bundle>No</SKU_Bundle>
    <SKU_Bundle_description code="No" mLang="1">
      <desc lang="en">No</desc>
      <desc lang="da-DK"> </desc>
    </SKU_Bundle_description>
    <SKU_Channel_Display_Category>B</SKU_Channel_Display_Category>
    <SKU_Channel_Display_Category_description code="Standard Product">Standard Product</SKU_Channel_Display_Category_description>
    <SKU_Color_description code="Silver" mLang="1">
      <desc lang="en">Silver</desc>
      <desc lang="da-DK"> </desc>
    </SKU_Color_description>
    <SKU_Color>Silver</SKU_Color>
    <SKU_EAN_Number> </SKU_EAN_Number>
    <SKU_ECCN_Number> </SKU_ECCN_Number>
    <SKU_Features> </SKU_Features>
    <SKU_For_Use_With mLang="1">
      <value lang="en"/>
      <value lang="da-DK"/>
    </SKU_For_Use_With>
    <SKU_GTIN_Number> </SKU_GTIN_Number>
    <SKU_Getting_Started_Copy mLang="1">
      <value lang="en">Professional installation gets professional results. Find an authorized professional near you to complete your installation.</value>
      <value lang="da-DK"> </value>
    </SKU_Getting_Started_Copy>
    <SKU_Global_ERP_Status_Code>01</SKU_Global_ERP_Status_Code>
    <SKU_Global_ERP_Status_Code_description code="Active">Active</SKU_Global_ERP_Status_Code_description>
    <SKU_Hazardous_Material_Code> </SKU_Hazardous_Material_Code>
    <SKU_Hazardous_Material_Description mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_Hazardous_Material_Description>
    <SKU_Includes mLang="1">
      <value lang="en">Four leveling feet with rubber isolation pads</value>
      <value lang="da-DK"/>
    </SKU_Includes>
    <SKU_Install_Type>Professional Install</SKU_Install_Type>
    <SKU_Install_Type_description code="Professional Install" mLang="1">
      <desc lang="en">Professional Install</desc>
      <desc lang="da-DK"> </desc>
    </SKU_Install_Type_description>
    <SKU_Is_Primary_SKU> </SKU_Is_Primary_SKU>
    <SKU_Keywords> </SKU_Keywords>
    <SKU_Literature_Language mLang="1">
      <value lang="en"/>
      <value lang="da-DK"/>
    </SKU_Literature_Language>
    <SKU_Long_Promotion_Description mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_Long_Promotion_Description>
    <SKU_Meta_Description>The DR90A3000/U Honeywell Home Dehumidification from Resideo is built to meet the specific needs for your home. Find product info and resources here.</SKU_Meta_Description>
    <SKU_Meta_Title>DR90A3000/U Dehumidification - Honeywell Home From Resideo</SKU_Meta_Title>
    <SKU_Name> </SKU_Name>
    <SKU_New_SKU_Effective_End_Date> </SKU_New_SKU_Effective_End_Date>
    <SKU_New_SKU_Effective_Start_Date> </SKU_New_SKU_Effective_Start_Date>
    <SKU_New_SKU_Effective_Timezone_description code=""> </SKU_New_SKU_Effective_Timezone_description>
    <SKU_New_SKU_Effective_Timezone> </SKU_New_SKU_Effective_Timezone>
    <SKU_New_SKU_Indicator_description code="No">No</SKU_New_SKU_Indicator_description>
    <SKU_New_SKU_Indicator>No</SKU_New_SKU_Indicator>
    <SKU_OG_Description>The DR90A3000/U Honeywell Home Dehumidification from Resideo is built to meet the specific needs for your home. Find product info and resources here.</SKU_OG_Description>
    <SKU_OG_Title>DR90A3000/U Dehumidification - Honeywell Home From Resideo</SKU_OG_Title>
    <SKU_PIM_SKU_Status>Published</SKU_PIM_SKU_Status>
    <SKU_PIM_SKU_Status_description code="Published">Published</SKU_PIM_SKU_Status_description>
    <SKU_PIM_Workflow_Ownership> </SKU_PIM_Workflow_Ownership>
    <SKU_Packaging_Material> </SKU_Packaging_Material>
    <SKU_Packaging_Shape_description code=" " mLang="1">
      <desc lang="en"> </desc>
      <desc lang="da-DK"> </desc>
    </SKU_Packaging_Shape_description>
    <SKU_Packaging_Shape> </SKU_Packaging_Shape>
    <SKU_Power_Source> </SKU_Power_Source>
    <SKU_Pro_Install>Yes</SKU_Pro_Install>
    <SKU_Pro_Install_description code="Yes">Yes</SKU_Pro_Install_description>
    <SKU_Pro_Meta_Description>The DR90A3000/U Honeywell Home dehumidifier from Resideo helps you create a more comfortable home for your customers. Find product info and resources here.</SKU_Pro_Meta_Description>
    <SKU_Pro_Meta_Title>DR90A3000/U Dehumidifier - Honeywell Home From Resideo</SKU_Pro_Meta_Title>
    <SKU_Pro_OG_Description>The DR90A3000/U Honeywell Home dehumidifier from Resideo helps you create a more comfortable home for your customers. Find product info and resources here.</SKU_Pro_OG_Description>
    <SKU_Pro_OG_Desription> </SKU_Pro_OG_Desription>
    <SKU_Pro_OG_Title>DR90A3000/U Dehumidifier - Honeywell Home From Resideo</SKU_Pro_OG_Title>
    <SKU_Product_Features mLang="1">
      <value lang="en"/>
      <value lang="da-DK"/>
    </SKU_Product_Features>
    <SKU_Product_Manager_description code=""> </SKU_Product_Manager_description>
    <SKU_Product_Manager> </SKU_Product_Manager>
    <SKU_Product_Manager_owner> </SKU_Product_Manager_owner>
    <SKU_Product_Number>DR-Series3</SKU_Product_Number>
    <SKU_Product_Taxonomy_Node>RMH Root.Air Treatment.Dehumidifiers</SKU_Product_Taxonomy_Node>
    <SKU_Product_Taxonomy_Node_description code="Dehumidifiers">Dehumidifiers</SKU_Product_Taxonomy_Node_description>
    <SKU_Program_Type> </SKU_Program_Type>
    <SKU_Promotion_Banner> </SKU_Promotion_Banner>
    <SKU_Promotion_Effective_End_Time> </SKU_Promotion_Effective_End_Time>
    <SKU_Promotion_Effective_Start_Time> </SKU_Promotion_Effective_Start_Time>
    <SKU_Promotion_Timezone> </SKU_Promotion_Timezone>
    <SKU_Promotion_Timezone_description code=""> </SKU_Promotion_Timezone_description>
    <SKU_Release_Indicator>PPR1</SKU_Release_Indicator>
    <SKU_Release_Indicator>CR2</SKU_Release_Indicator>
    <SKU_Release_Indicator_description code="RDE Pro Public Release 1">PPR1</SKU_Release_Indicator_description>
    <SKU_Release_Indicator_description code="RDE Consumer Release 2">CR2</SKU_Release_Indicator_description>
    <SKU_Resideo_Workflow_Status> </SKU_Resideo_Workflow_Status>
    <SKU_SKU_Accessory_Part_Description mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_SKU_Accessory_Part_Description>
    <SKU_SKU_Asset_Status>Completed</SKU_SKU_Asset_Status>
    <SKU_SKU_Asset_Status_description code="Completed">Completed</SKU_SKU_Asset_Status_description>
    <SKU_SKU_Compatibility_Description mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_SKU_Compatibility_Description>
    <SKU_SKU_Detail_Page_Title> </SKU_SKU_Detail_Page_Title>
    <SKU_SKU_ID>501</SKU_SKU_ID>
    <SKU_SKU_Long_Description> </SKU_SKU_Long_Description>
    <SKU_SKU_Replacement_Part_Description mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_SKU_Replacement_Part_Description>
    <SKU_SKU_Sequence_Order>1</SKU_SKU_Sequence_Order>
    <SKU_SKU_Short_Description>DR90 Whole House Dehumidifier</SKU_SKU_Short_Description>
    <SKU_SKU_Title mLang="1">
      <value lang="en">90-Pt. TrueDRY Whole Home Dehumidification System</value>
      <value lang="da-DK"> </value>
    </SKU_SKU_Title>
    <SKU_Sequence> </SKU_Sequence>
    <SKU_Short_Promotion_Description mLang="1">
      <value lang="en"> </value>
      <value lang="da-DK"> </value>
    </SKU_Short_Promotion_Description>
    <SKU_Sold_By_Retailer>No</SKU_Sold_By_Retailer>
    <SKU_Sold_By_Retailer_description code="No">No</SKU_Sold_By_Retailer_description>
    <SKU_Sold_Direct_To_Consumer_description code="No">No</SKU_Sold_Direct_To_Consumer_description>
    <SKU_Sold_Direct_To_Consumer>No</SKU_Sold_Direct_To_Consumer>
    <SKU_Syndication_Channel>RPH</SKU_Syndication_Channel>
    <SKU_Syndication_Channel>RCH</SKU_Syndication_Channel>
    <SKU_Syndication_Channel>HWH</SKU_Syndication_Channel>
    <SKU_Syndication_Channel>PED</SKU_Syndication_Channel>
    <SKU_Syndication_Channel_description code="Pro North America">RPH</SKU_Syndication_Channel_description>
    <SKU_Syndication_Channel_description code="Consumer United States">RCH</SKU_Syndication_Channel_description>
    <SKU_Syndication_Channel_description code="Honeywell Home">HWH</SKU_Syndication_Channel_description>
    <SKU_Syndication_Channel_description code="Power Equipment Direct">PED</SKU_Syndication_Channel_description>
    <SKU_Type_description code="Dehumidifiers" mLang="1">
      <desc lang="en">Dehumidifiers</desc>
      <desc lang="da-DK"> </desc>
    </SKU_Type_description>
    <SKU_Type>Dehumidifiers</SKU_Type>
    <SKU_UPC_Number>85267421515</SKU_UPC_Number>
    <SKU_Use> </SKU_Use>
    <pk1SKU>ABCDEFG</pk1SKU>
    <Package_Height>
      <sequencePim>0</sequencePim>
      <SKU_Package_Height>25.2</SKU_Package_Height>
      <SKU_Package_Height_UoM>in</SKU_Package_Height_UoM>
      <SKU_Package_Height_UoM_descriptionDesc code="Inch">in</SKU_Package_Height_UoM_descriptionDesc>
    </Package_Height>
    <Product_Height>
      <sequencePim>0</sequencePim>
      <SKU_Product_Height>19.3</SKU_Product_Height>
      <SKU_Product_Height_UoM>in</SKU_Product_Height_UoM>
      <SKU_Product_Height_UoM_descriptionDesc code="Inch">in</SKU_Product_Height_UoM_descriptionDesc>
    </Product_Height>
    <Package_Length>
      <sequencePim>0</sequencePim>
      <SKU_Package_Length>35.8</SKU_Package_Length>
      <SKU_Package_Length_UoM_descriptionDesc code="Inch">in</SKU_Package_Length_UoM_descriptionDesc>
      <SKU_Package_Length_UoM>in</SKU_Package_Length_UoM>
    </Package_Length>
    <Package_Width>
      <sequencePim>0</sequencePim>
      <SKU_Package_Width>19.3</SKU_Package_Width>
      <SKU_Package_Width_UoM_descriptionDesc code="Inch">in</SKU_Package_Width_UoM_descriptionDesc>
      <SKU_Package_Width_UoM>in</SKU_Package_Width_UoM>
    </Package_Width>
    <Product_Length>
      <sequencePim>0</sequencePim>
      <SKU_Product_Length>19.3</SKU_Product_Length>
      <SKU_Product_Length_UoM_descriptionDesc code="Inch">in</SKU_Product_Length_UoM_descriptionDesc>
      <SKU_Product_Length_UoM>in</SKU_Product_Length_UoM>
    </Product_Length>
    <Product_Width>
      <sequencePim>0</sequencePim>
      <SKU_Product_Width>14.3</SKU_Product_Width>
      <SKU_Product_Width_UoM_descriptionDesc code="Inch">in</SKU_Product_Width_UoM_descriptionDesc>
      <SKU_Product_Width_UoM>in</SKU_Product_Width_UoM>
    </Product_Width>
    <Package_Weight>
      <sequencePim>0</sequencePim>
      <SKU_Package_Weight>108.6</SKU_Package_Weight>
      <SKU_Package_Weight_UoM>lb</SKU_Package_Weight_UoM>
      <SKU_Package_Weight_UoM_descriptionDesc code="Pound">lb</SKU_Package_Weight_UoM_descriptionDesc>
    </Package_Weight>
    <dynamicAttr>
      <attrName>Drain Connection Size</attrName>
      <attrValue> </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Drain Connection Type</attrName>
      <attrValue mLang="1">
        <value lang="en"> </value>
        <value lang="da-DK"> </value>
      </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Dehumidifying Capacity (Max)</attrName>
      <attrValue mLang="1">
        <value lang="en">90 pints per day</value>
        <value lang="da-DK"/>
      </attrValue>
      <attrValue mLang="1">
        <value lang="en"> 45 liters per day</value>
        <value lang="da-DK"/>
      </attrValue>
      <desc code="">90 pints per day| 45 liters per day</desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Power Supply Frequency</attrName>
      <attrValue mLang="1">
        <value lang="en"/>
        <value lang="da-DK"/>
      </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Building Size (Max)</attrName>
      <attrValue mLang="1">
        <value lang="en"/>
        <value lang="da-DK"/>
      </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Energy Performance</attrName>
      <attrValue mLang="1">
        <value lang="en">2.9 liters per KWH </value>
        <value lang="da-DK"> </value>
      </attrValue>
      <desc code="">2.9 liters per KWH </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Dehumidification Collar Diameter</attrName>
      <attrValue> </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Operating Voltage</attrName>
      <attrValue mLang="1">
        <value lang="en"/>
        <value lang="da-DK"/>
      </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Current Draw</attrName>
      <attrValue mLang="1">
        <value lang="en">5.3 A</value>
        <value lang="da-DK"> </value>
      </attrValue>
      <desc code="">5.3 A</desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Recommended Service Life</attrName>
      <attrValue mLang="1">
        <value lang="en"> </value>
        <value lang="da-DK"> </value>
      </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Ventilation Collar Diameter</attrName>
      <attrValue> </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Thermal Charge</attrName>
      <attrValue mLang="1">
        <value lang="en"/>
        <value lang="da-DK"/>
      </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Power Consumption</attrName>
      <attrValue mLang="1">
        <value lang="en">120 VAC</value>
        <value lang="da-DK"/>
      </attrValue>
      <desc code="">120 VAC</desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Building Square Footage (Max)</attrName>
      <attrValue mLang="1">
        <value lang="en">Up to 2800 sq. ft.</value>
        <value lang="da-DK"> </value>
      </attrValue>
      <desc code="">Up to 2800 sq. ft.</desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Energy Star Certified</attrName>
      <attrValue>Yes</attrValue>
      <desc lang="en"> </desc>
      <desc lang="da-DK"> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Auxiliary Outputs</attrName>
      <attrValue> </attrValue>
      <desc lang="en"> </desc>
      <desc lang="da-DK"> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Ambient Operating Temperature (Max)</attrName>
      <attrValue mLang="1">
        <value lang="en"/>
        <value lang="da-DK"/>
      </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
    <dynamicAttr>
      <attrName>Ambient Operating Temperature (Min)</attrName>
      <attrValue mLang="1">
        <value lang="en"/>
        <value lang="da-DK"/>
      </attrValue>
      <desc code=""> </desc>
    </dynamicAttr>
  </SKU>
</Root>

informatica映射如下所示

​

​

JOINERS和SORTERS看起来

​

​

​

​

​

我在这里做了什么错事吗(我当然知道我做错了什么)。请帮助我解析

XML层次分析信息

​

xml-parsing
informatica
informatica-powercenter
informatica-cloud
EN

回答 1

Stack Overflow用户

发布于 2020-09-28 07:58:05

您可以尝试使用速度变换。此选项需要单独的许可证。如果可用，您可以使用单个转换来处理XML的层次结构，比如在示例中。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/63606873

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档