IICS | Hierarchy Builder Transformation | Create JASON file from Oracle

Hi Friends , in this video , we will learn how to create JASON file using Hierarchy Builder Transformation from Oracle .

#iics #informatica #informática

below is DDL for oracle source and sample data :
CREATE TABLE "TGT"."EMP_JASON"
( "EMP_ID" NUMBER(38,0),
"FIRST_NAME" VARCHAR2(100 BYTE),
"MIDDLE_NAME" VARCHAR2(50 BYTE),
"LAST_NAME" VARCHAR2(100 BYTE)
)

data :
Insert into EMP_JASON (EMP_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME) values (10,'RAM',null,'SINGH');
Insert into EMP_JASON (EMP_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME) values (20,'DEV',null,'PATEL');
Insert into EMP_JASON (EMP_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME) values (30,'DINESH',null,'SAHU');
Insert into EMP_JASON (EMP_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME) values (40,'MARK',null,'COTTS');
Insert into EMP_JASON (EMP_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME) values (50,'JULIE',null,'PARK');
Insert into EMP_JASON (EMP_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME) values (60,'JAY',null,'SEAN');

below is sample jason file you can copy paste and use it for your hierarchal schema

[
{
"EMP_ID": 10,
"FIRST_NAME": "RAM",
"MIDDLE_NAME": null,
"LAST_NAME": "SINGH"
},
{
"EMP_ID": 20,
"FIRST_NAME": "DEV",
"MIDDLE_NAME": "UMESH",
"LAST_NAME": "PATEL"
},
{
"EMP_ID": 30,
"FIRST_NAME": "DINESH",
"MIDDLE_NAME": "K",
"LAST_NAME": "SAHU"
}
]

You can watch my previous video where i had loaded jason to oracle .

[gauravpandey]

Thanks for sharing info…please keep it up..👍

[vijaykumarhiremath]

Hi Roshan, Thanks for the amazing and informative videos. Could you please make a videos on Real Project explanation and scenarios.

[sumanprasad]

Hello Roshan, Your videos are very informative. Thanks for uploading such videos. Can you please upload a video on how to migrate Powercenter mapping to IICS cloud. Thanks

[ETLSTATION]

Hi Friends, in this video, we will learn how to create JASON file using Hierarchy Builder Transformation from Oracle .

#iics #informatica #informática

below is DDL for oracle source and sample data :
CREATE TABLE "TGT"."EMP_JASON"
( "EMP_ID" NUMBER(38, 0),
"FIRST_NAME" VARCHAR2(100 BYTE),
"MIDDLE_NAME" VARCHAR2(50 BYTE),
"LAST_NAME" VARCHAR2(100 BYTE)
)

data :
Insert into EMP_JASON (EMP_ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME) values (10, 'RAM', null, 'SINGH');
Insert into EMP_JASON (EMP_ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME) values (20, 'DEV', null, 'PATEL');
Insert into EMP_JASON (EMP_ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME) values (30, 'DINESH', null, 'SAHU');
Insert into EMP_JASON (EMP_ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME) values (40, 'MARK', null, 'COTTS');
Insert into EMP_JASON (EMP_ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME) values (50, 'JULIE', null, 'PARK');
Insert into EMP_JASON (EMP_ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME) values (60, 'JAY', null, 'SEAN');

below is sample jason file you can copy paste and use it for your hierarchal schema

[
{
"EMP_ID": 10,
"FIRST_NAME": "RAM",
"MIDDLE_NAME": null,
"LAST_NAME": "SINGH"
},
{
"EMP_ID": 20,
"FIRST_NAME": "DEV",
"MIDDLE_NAME": "UMESH",
"LAST_NAME": "PATEL"
},
{
"EMP_ID": 30,
"FIRST_NAME": "DINESH",
"MIDDLE_NAME": "K",
"LAST_NAME": "SAHU"
}
]




You can watch my previous video where i had loaded jason to oracle .

[aravindkumar]

Hii roshan can make a videos on CAI also...and also unix scripting

[sufians]

Hi Roshan, waiting for this video and more and more! want to thanks a lot for your videos.

[venkateshmangamolla]

Bro kindly make one video on most asked informatica scenario based interview questions it's help us...

[aravindkumar]

Hii roshan plzz make a video on partitions in iics...i had searched most of the videos but i didnt find the right one...plzz make a video on partitions

[sanjivh]

Hi sir, would please explain what is dynamic schema handling

[anupammishra]

Hi Roshan, thanks for the informative video. Could you please make a video on the command task notification which reads only one file of same pattern from the given directory in shell script and process the remaining taskflow otherwise skips the remaining the taskflow and succeeds it.

[iicsproject-gilq]

HI Roshan bro please make one session on deployment to DEV to PROD environment and UAT document and in the deployment what kind of problems and issues will trigger how can we resolve them...waiting for your response___your subscriber

[balu]

There is an update, to make it a single tag in XML or Json we have an option in Hierarchy Builder's output settings. select the generate the single output option. We dont need to take the dummy source and all.

[samhudaya]

Can you do video performance tuning on iics?