2 Replies Latest reply: Jan 21, 2013 2:07 PM by Vishwaranjan Kumar RSS

    Mapping load

    SIVASUBRAMANIAN KNK

      Does mapping load requires two columns of data? Is it necessary?

        • Re: Mapping load
          Mohit Sharma

          the purpose of using mapping load is to drop one field of one table to other table

          for this in two tables you have must  one primary key then using mapping load,

          load 1st field which is primary key to both table and through that field load another field which you want to drop it in another table while execution...

          • Re: Mapping load
            Vishwaranjan Kumar

            hi

            the concept of mapping table is that,

            the mapped table(table1) have atleast two column(field name), 1st column must be primary key and on the basis of it we mapped the 2nd column from table2.

            primary key must be common in both table.

            example--

            mapping load

                           productid,

                           productname     from table1;

             

            load orderid,

                   item,

                   quantity,

                   productid

            Applymap('table1',productid) as productname

            from table2;

             

            hope this helps you.