7 Replies Latest reply: Jun 10, 2015 5:25 AM by Prashant Sangle RSS

    Concatenate load problem

    kumar avisakula

      Hi,

       

      I have two dimension tables say dim_a and dim_b. dim_a is columns like

       

      dim_a

      a1,

      a2,

      a3,

      a4

      .

      .

      .

       

       

      dim_b

      a1,

      a2,

      b1,

      b2,

      .

      My requirement is I need merge these as a single table. I am done with

       

      dim_a

      a1,

      a2,

      a3,

      a4

      .

      .

      .

       

      concatenate(dim_a)

      LOAD dim_b

      a1,

      a2,

      b1,

      b2,

      .

       

      I am able to merge these two tables as single but the problem is here I am able to see only dim_a table data but I am not able to see data from dim_b.

       

      Pls help me out on this issue.

       

      Regards,

      KUmar