XML Read in Informatica BDM 10.5.3
I am trying to real XML file in Informatica BDM and load this in Teradata table. For this I have created a PDO with complex file data object with below configuration. XML file is placed at my local path.
- Resource format: XML
- Choose XML file from my local path
Complex file data object is created with 2 columns Data and filename. Data column name has type binary and filename has string.
Then, I created hierarchy to relational transformation and chose the XML file to parse it. I have provided the same file as schema and I can see it is parsed successfully
In mapping, I dragged the complex file data object PDO and then hierarchy to relational transformation and then target PDO.
In my complex file data object, I have mentioned File Format = Custom Input.
When I run data viewer, it says file does not exist at my local path, however it is available. Below is the error screenshot:
As I said in the comment that I have updated the mapping by adding source PDO as flatfile source, then added XML file path to the flatfile source, but still having the error:
"Unable to real input document"
From logs it had been verified that XML is read successfully from the flat file path so there is no issue in that.
For hierarchy to relational transformation, in Output Mapping, you can see there are 2 areas, one is transformation input on the left and other is transformation output on the right. I need only few tags from my XML and I have updated it to only get that tag as my root from Choose Hierarchy option on right hand side. Please see below screenshot.
Due to this, there is a mismatch between the XML read from source and transformation in hierarchy to relational transformation.
To resolve this I have selected the main tag as root from my XML and they input and transformation input/output are synchronized. This change had resolved my issue and I am now successfully able to load data into the Teradata tables
- Convert iff expression in informatica to snowflake query
- Which one is better performance wise in Informatica Powercenter? Use sorter transformation or add number of sorted ports on source qualifier?
- Using a Command Task to create a shell to run the same workflow again in a loop using nohup
- Using REG_MATCH and REPLACESTR function in Informatica to replace a suffix character
- Pick the latest file based on datestamp provided in the filename
- Informatica cloud data quality rule validation issue
- Avoiding dupicate target file in Informatica
- Date Formats comparison in Informatica
- Instr to find the exact pattern match in informatica
- Informatica new line and carriage return
- Replace SAS stored process with different ETL tool
- Informatica Data Quality Developer Tool Parameter file
- How to check the used space during run of an Informatica Powercenter Workflow?
- Create a file list in IICS informatica and load the files to a table
- XML Read in Informatica BDM 10.5.3
- IICS: multiple queries into one flat file
- Cannot convert type string to date
- How to compare string with Latin characters to same string with English characters in IICS?
- How to call materialized views using informatica power center?
- REG_EXTRACT doesnt work in IICS Informatica
- How to create repeted seq in informatica?
- Cannot connect Informatica to the Oracle DB on Docker
- Need Regex code, 6 character alphanumeric
- How to write regex or any replace function to replace with null where [,-] pattern exist
- How to load Multiple excel source files with different structure into a target table in Informatica
- Informatica power center parameters with multiple values
- Find the folder name and mapping name details impacted by particular target table in informatica
- Informatica: How to filter a table based on aggregation result of another table?
- Compare the count of two tables in informatica
- Create the Mapping and Display Runs For Each Over and I Also Add First Over Runs in the Sum of Second Over Runs and Same for Third Over