Skip to content
Thursday, April 22, 2021

IT Talkers

Technology HUB

  • ETL
    • Pentaho
    • Tableau
  • SCRIPTING
    • Shell Script
  • AWS
    • ATHENA
    • S3
    • SQL_SERVER
  • Git GUI
  • C++
    • C++11
    • C++98
  • DATABASE
    • HIVE
    • ORACLE
    • SQL_SERVER
  • BIG DATA
    • HDFS
  • SAS
  • Data Structure
    • Stack
  • Networking

Tag: creating table based on metadata file

create table dynamically based on Metadata file and load the source file into that table in pentaho

admin

Today , i will discuss about creating the table based on metadata file and then loading the source file into that table.Below is the image of ETL job. First, loading the metadata file into a table, means loading the metadata file which has details like column name ,column type and column length. In this ktr (loading_metadata_file), loading the metadata file to a table TBL_METADATA_STORE. Below is the DDL of this table.I am using mysql as database. CREATE TABLE `tbl_metadata_store` ( `column_name` varchar(100) DEFAULT NULL, `data_type` varchar(100) DEFAULT NULL, `col_len` int(11)…

ETL, Pentahocreating table based on metadata file, dynamic table creation in mysql, loading the changing source file into table in pentaho6 Comments

Recent Posts

  • Dynamic Cast
  • DHCP
  • Conversions
  • IPv4 Address
  • Call Pentaho Job using Batch Script
  • Queue using stack
  • nullptr
  • auto keyword
  • GET HIERARCHICAL VALUES PRESENT IN SAME COLUMN OF A TABLE
  • Stack Using Linked List

Categories

all about technology

Proudly powered by WordPress | Theme: AcmeBlog by AcmeThemes.