Skip to content
Wednesday, August 10, 2022
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

  • Remove trailing spaces and zero from a string in SQL-Server
  • Remove Leading Zeros and Spaces In SQL-SERVER
  • Difference between Unix and PowerShell Commands
  • ORACLE INTERVIEW QUESTIONS
  • Examples of Awk Command
  • Check existence and non-existence of columns in a table
  • get all Values separated by delimiter in sql
  • Delete data from Access Database in Pentaho
  • select Query using Access database in Pentaho
  • Create Access Database Connection In Pentaho

Categories

all about technology

Proudly powered by WordPress | Theme: AcmeBlog by AcmeThemes.