4 Replies Latest reply: Sep 6, 2011 9:51 AM by Goran Korsgren RSS

    how do i concat multiple fact table with same field with a flag?

    Sushil Kumar

      Hi All,

       

      I have two fact table

       

      table one:

       

      location_code

      area_code

      time_id

      defects

      processed

       

      table two;

       

      location_code

      area_code

      time_id

      defects

      processed

      failure

       

      and dimensions are time,location and area

       

      how would i concat them into a single table such that after concating i am able to know which field is from which table....(means how do i add flag)

       

      Please help me out...

      Thanks