filmov
tv
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 .
#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 .
Комментарии