1 Reply Latest reply on Oct 30, 2012 3:54 PM by Ramesh Reddy

    MetaData getTables() returns a lot of extra tables which are not in the original database

    Ivan Chan Apprentice

      when I call getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) from VDS metadata, it returns a lot of extra tables which are not in the original database.  Is it a way to skip those extra tables when calling getTables().

       

      Sample of Exta Tables when combining foodmart:

       

      i_account_id

      i_account_parent

      i_category_id

      i_category_parent

      i_currency

      i_cust_acct_num

      i_cust_child_home

      i_cust_postal_code

      i_cust_region_id

      i_customer_fname

      i_customer_id

      i_customer_lname

      i_department_id

      i_empl_closure

      i_empl_closure_emp

      i_empl_dept_id

      i_empl_store_id

      i_empl_super_id

      i_employee_id

      i_expense_acct_id

      i_expense_store_id

      i_expense_time_id

      i_inv_97_prod_id

      i_inv_97_store_id

      i_inv_97_time_id

      i_inv_97_wrhse_id

      i_inv_98_prod_id

      i_inv_98_store_id

      i_inv_98_time_id

      i_inv_98_wrhse_id

      i_position_id

      i_prod_brand_name

      i_prod_class_id

      i_product_SKU

      i_product_id

      i_product_name

      i_promo_dist_id

      i_promotion_id

      i_rsrv_empl_dept

      i_rsrv_empl_id

      i_rsrv_empl_store

      i_rsrv_empl_sup

      i_salary_employee

      i_salary_pay_date

      i_sls97c14cust

      i_sls97c14prod

      i_sls97c14promo

      i_sls97c14store

      i_sls97gmp_gender

      i_sls97gmp_ms

      i_sls97gmp_pcat

      i_sls97gmp_pdept

      i_sls97gmp_pfam

      i_sls97gmp_tmonth

      i_sls97gmp_tquarter

      i_sls97gmp_tyear

      i_sls97l05cust

      i_sls97l05prod

      i_sls97l05promo

      i_sls97l05store

      i_sls97lc100cust

      i_sls97lc100prod

      i_sls97ll01cust

      i_sls97ll01prod

      i_sls97ll01time

      i_sls97pl01cust

      i_sls97pl01prod

      i_sls97pl01time

      i_sls97speccust.....