APP? yopu mean script i can send it over like it ..its almost the same,i use a relationl db as source
SQL SELECT
group_id as ns_group_id, ----MY PRIMARY KEY
group_id as ns_group_id_pk,
base_date as ns_base_date,
product_number as ns_product_number,
base_year_week_number as ns_year_week_number,
FROM "PLAY_PEN"."allgroups_key_d";
SQL SELECT
group_id as ns_group_id, ----MY PRIMARY KEY
group_id as cs_group_id,
base_date as cs_base_date,
product_number as cs_product_number,
base_year_week_number as base_year_week_number,
long_description as cs_long_description,
offer_end_date as cs_offer_end_date,
offer_end_week as cs_offer_end_week,
FROM "PLAY_PEN"."allgroups_key_d";
SQL SELECT
offer_number as promos_offer_number_ns,
product_number as promos_tpnb_ns,
trim(aaaa)||trim(bbbb) as ns_group_id, ----MY PRIMARY KEY
trim(aaaa)||trim(bbbb) as ns_group_id_fp,
long_description as ap_long_description_ns,
offer_start_date as ap_offer_start_date_ns,
offer_end_date as ap_offer_end_date_ns,
FROM "PLAY_PEN"."allfuture_groups_d";
SQL SELECT
offer_number as promos_offer_number_cs,
product_number as promos_tpnb_cs,
trim(aaaa)||trim(bbbb) as ns_group_id, ----MY PRIMARY KEY
trim(aaaa)||trim(bbbb) as cs_group_id_fp,
price as base_date_cs
FROM "PLAY_PEN"."allfuture_groups_d";
SQL SELECT
offer_number as offer_number_cs,
product_number as product_number_cs,
trim(aaaa)||trim(bbbb) as ns_group_id, ----MY PRIMARY KEY
trim(aaaa)||trim(bbbb) as group_id_cs_alp,
opted_in as opted_in_cs
FROM "PLAY_PEN"."allAll_groups_d";
SQL SELECT
offer_number as offer_number_ns,
product_number as product_number_ns,
trim(aaaa)||trim(bbbb) as ns_group_id, ----MY PRIMARY KEY
trim(aaaa)||trim(bbbb) as group_id_ns_alp,
ofr_offer_end_date as ofr_offer_end_date_ns
FROM "PLAY_PEN"."allAll_groups_d";
