IICS | HIERARCHY PARSER Transformation in Informatica Cloud | Load Jason file to Oracle

[@kamasanichittibabu5013]

One of the best channel to learn IICS.. Thankyou

[@vijaykumarhiremath7501]

Hi Roshan, Thank you so much for this video. can you please create a video on difference between hierarchical schema and intelligent structure model

[@ETLSTATION]

The Structure Parser transformation transforms your input data into a user-defined structured format based on an intelligent structure model . You can use the Structure Parser transformation to analyze data such as log files, clickstreams, XML or JSON files, Word tables, and other unstructured or semi-structured formats. VS The Hierarchy Parser transformation converts hierarchical input into relational output. The transformation processes XML or JSON input from the upstream transformation and provides relational output to the downstream transformation.

[@SaiTeja-pw6iq]

Hi Roshan, if you observe the results, middle name is not populated into the table. Why so?

[@ETLSTATION]

may be column is not mapped in hierarchy parser mapped fields , you can connect and run

[@bindusai03]

Hi, useful vedio. thank you for vedio. If in a table one of the column having json data. Need to load json column data into relational columns along with other columns from source which are regular fields like key,st_dt,end_dt etc. Can you help me to resolve this issue.

[@ETLSTATION]

hi your question is not very clear , are you saying you have two sources , one jason and one relational and u want data from jason file to same target as relational table , then u can join the jason and relational right . use structure parser transformation to convert jason file in relational output . then join this pipeline with relational source using joiner and load into same target table . watch my video jason to snowflake

[@subhashini25b]

Hi Roshan while I ran the job I got the error cannot create an Unstructured Data transformation. Can I know the reason for this.

[@nishantchavan2980]

hello roshan, thanks for your contribution. If we have multiple sources xml, json, relational table and flat file then how to integrate data in iics TARGET TABLE AS TARGET ? pl suggest solution,

[@ETLSTATION]

use hierarchy parser or intelligent structure parser to convert xml and jason in different pipline , same for flat file and relational , then join the pipelines using joiner or you can try union transformation as well .

[@nishantchavan2980]

@@ETLSTATION thanks for reply, make a small video or short if possible that will help to understand deeply. thanks in advance roshan

[@ETLSTATION]

@@nishantchavan2980 did you watch joiner transformation video ? and how to load xml and jason file to oracle. if yes then its easy right , once xml and jason are in relational format , its same as any other join condition

[@somasekharnaidu750]

Great job But I want to load data from Oracle to JSON file (or) MongoDB collection so Can you make a video ?

[@Raviiicslearn]

Hi Roshan , I've a question on Hierarchy Parser Transformation , at input settings -- there are two options 1 Buffer 2 File , in the video you choose File . In what scenario we select buffer , what is buffer ? Any idea? Also If you have time please create any telegram channel that helps for people to ask questions and you can post your upcoming videos as well to reach your audiences

[@kishorep6806]

Hi Roshan , So Lets we assume that the json file is present in one of the column in the relational database at that time what will be the procedure and explain how to do that so even i will send a file please go through that and provide some solution for that . i couldn't able to do transformation in the informatica and ur content is good keep going

[@dharanih9083]

Hi Bro Can you explain about CDI & CAI pls Cloud data integration & Cloud Application integration

[@ETLSTATION]

hi dharani , all my videos and tutorials are covering CDI , which stands for cloud data integration which is similar to powercenter tool of informatica or ssis or abnitio or other etl tools . CAI , i will see since i primarily work in CDI .