Skip to content
Saturday, April 1, 2023
IT Talkers
  • ETL
    • Pentaho
    • Tableau
  • SCRIPTING
    • Shell Script
  • AWS
    • ATHENA
    • S3
    • SQL_SERVER
  • Git GUI
  • DB
    • HIVE
    • ORACLE
    • SQL_SERVER
  • BIG DATA
    • HDFS
  • SAS
  • Tutorials
    • C++11
      • Basics
    • C++98
      • Basics
      • Const Keyword
      • Friend Keyword
      • Polymorphism
      • Memory Allocation
      • Static Keyword
      • Miscellaneous
    • Networking
    • Data Structure
      • Stack
  • Contact Us

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 pentaho

Recent Posts

  • Find Uncommon Characters in two Strings
  • Parenthesis Check in Linux
  • Minimum Index of all Characters in a String
  • Get all distinct Character in a string
  • Remove all repeated Characters in a String
  • Find first repeated character
  • Count Inversions in Array
  • kth smallest element in array
  • Groups in Array
  • Rearrange array alternatively

Categories

all about technology

Proudly powered by WordPress | Theme: AcmeBlog by AcmeThemes.