Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Unanswered: fact table integration

    Hi people,

    I have one question...so i have to integrate and consolidate fact tables
    and i will to integrate ten stores but two stores in parallel for each time.

    Example:

    table dimension:
    STR_ID WeeK
    75 25
    76 25...i have to integrate theses two stores in parallel

    77 25
    78 25... " " " " "

    .
    .
    .
    84..and we have ten stores integrated!

    Repeat the same process for the next week,it's the same process.

    STR_ID WeeK
    75 26
    76 26
    etc...
    76

    Somebody could tell me how i can integrate two stores in parallel...I could could export each store to a flat file or directly of a table.

    I work with db2 udb 7.2, the stored procedure builder and the data warehouse center.

    Thanks for your help!

    Rui

  2. #2
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74
    ...when i finish the integration for one week i have to update the control table that store the curent week, ,,i have to increment one week,,,
    so when i use the procedure that integrate the stores i have to receive an parameter from the control table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •