IICS: Connection and Object Parameterization in Normalizer Transformation

#iics #etlguru #antosh
IICS: Connection and Object Parameterization in Normalizer Transformation

Before watching this video watch the Normalization Transformation implementation video the link is:   • IICS Normalizer Transformation  

#iics #etlguru #antosh
IICS Normalizer Transformation

SRC
Name,Maths,Physics,Chemistry
Antosh,80,60,70
Mahadev,90,70,80
Krishna,95,75,85


TGT
CREATE TABLE tgt_normalizer(
name varchar2(30),
subject varchar2(20),
marks number(3),
gk_marks number(3),
gcid_marks number(3)
);

Expression
DECODE(TRUE,
GCID_Marks=1,'Maths',
GCID_Marks=2,'Physics',
GCID_Marks=3,'Chemistry')

Parameter File
#USE_SECTIONS
[ETLGuru].[ETLGuru].[mct_m_nor_tr1]
$$TGT_DB=tgt_normalizer
$$TGT_SNW_Conn=SnowflakeODBC_Connection
$$SRC_File=normalizer_tr.csv
$$SRC_FF_Connection=Flat_file_Connection_SA1
[Global]