5 Replies Latest reply: Jul 2, 2014 2:58 PM by Massimo Grossi RSS

    concatenated tables and then join

    Vinay Bangari

      Hi ,


      I have a wierd scenario that is



      load A, B, C

      from table1;



      load A, B, C

      from table2;



      load A, B, C

      from table3;



      Load A, B, D, E from facttable_*;



      after join statement facttable_* , Here * indicates years 2011, 2012, 2013. it will have 3 tables which needs to be concatenated and then join. Problem from me is , the second (2012 ) QVD and third 2013 QVD is not joining properly. Because of that i am not getting the data from the second and 3rd QVD. Need your inputs on how to solve this issue.