5 Replies Latest reply on Aug 28, 2021 4:46 AM by Jagadish Mohan Gaglani

    Developer Mapping Invalid Object

    Jagadish Mohan Gaglani Guru

      Hi ,

       

      I have one of Developer Mapping in which one of Target Columns were deleted by mistake in DB. But when I run my developer mapping (BDM) - it does not fail - May I know the reason why it does not faik.

       

       

      Thanks,

      Jagadish

        • 1. Re: Developer Mapping Invalid Object
          Juan Gutierrez Ruiz Seasoned Veteran

          Hi Jagadish,

           

           

          How are you running the mapping? is the mapping dynamic? Have you selected the check box to dynamically get the target columns on run time?

           

          Thanks,

           

          Juan

          • 2. Re: Developer Mapping Invalid Object
            Krishnan Sreekandath Seasoned Veteran

            Hello Jagadish,

             

            In addition to Juan's suggestion above, please do confirm if you're loading this column as well or if it has been kept unmapped from any upstream transformations.

             

            Thanks,

            Krishnan

            • 3. Re: Developer Mapping Invalid Object
              user186817 Guru

              Hi Jagadish,

               

              Look into your mapping log and review the INSERT/UPDATE/DELETE sentences.

              The 'deleted' column is part of these?

              If you can't find that column, then you have the reason why the mapping didn't fail.

               

              Regards,
              Lluís

              • 4. Re: Developer Mapping Invalid Object
                Juan Gutierrez Ruiz Seasoned Veteran

                Hi Jagadish,

                 

                May I ask you if any of above answer helped in solving your issue? Otherwise please let us know if you have other queries.

                 

                 

                Thanks,

                 

                Juan

                • 5. Re: Developer Mapping Invalid Object
                  Jagadish Mohan Gaglani Guru

                  Hi Juan/Krishnan/Lluís,

                   

                  Apologies for replying so late .

                   

                  The mapping is not dynamic - I run them with no changes in mapping . Only to ensure that due to changes in DB - Does my ETL give me SQL Server error. It is NULL Column it may or may not have value . It has been kept mapped in Upstream Transformation. Source is Hive View and Target is SQL Server - Simple one to one load

                   

                  I have looked into mapping Log task and did not find any INSERT/UPDATE/DELETE statement as part of Log.

                   

                  Which means i takes mapping as in-memory and does not seem to map to Actual DB(SQL Server) which confuses me a bit . If we compare the same scenario with Informatica Power Center 10.2.0 HF2 then Power Center Session Log does issue SQL Server error that so and so Column is not found . AsMapping tries to map to actual DB Column.

                   

                   

                  BTW, As part of my Overall ETL Development - I use two tools , one is Developer (Hive to SQL Server) , other is Power Center (SQL Server to SQL Server  source to Target Load)

                   

                   

                  Env:

                  Informatica Developer Tool 10.2.0

                  SQL Server

                  Informatica Power Center 10.2.0

                   

                  Thank you Lluís for coming back to me . And Thank you everyone for helpful answers.

                   

                  Regards,

                  Jagadish