3 Replies Latest reply on Sep 15, 2020 3:20 PM by Shivanga Srinivas Bandaru

    Post validation tasks after informatica upgraded to 10.4

    user177476 New Member

      Need check list of testing activities after Informatica powercenter10.1.1 is upgraded to 10.4

        • 1. Re: Post validation tasks after informatica upgraded to 10.4
          Syed Aziz Guru

          Hello User,

           

          You can create and run validation tests from within the Data Validation Client. Also, you can view test results and run reports from within the Data Validation Client.

           

          Use the following process to perform data validation:

          1. Determine the validation requirements.

          2. Optionally, create a data validation view to represent one or more data sources.

          3. Create a table object that contains one or more data sources or views.

          4. Create a test to validate data in the table object.

          5. Run the test.

          6. View test results.

           

          More Information

          Step 1. Determine the validation requirements.

          Before you create a validation test, you first determine the testing requirements. Identify the data sources in the PowerCenter repository that contain data that you need to validate. If the validation is fairly straightforward, you can add the data source or data sources to a table object. If the validation is more complex, you might need to create a view with one or more data sources and then add the view to a table object.

           

          Step 2. Create a data validation view.

          You might need to create a data validation view based on an SQL query or based on one or more data sources.

          When you create a data validation view, the PowerCenter Integration Service stores the view definition in the Data Validation Option repository. You can edit the view in the Data Validation Client.

           

          Step 3. Create a table object.

          After you create a view, you can add it to a table object. Create a table object that contains one or more table definitions or views. You can create a single table object or a table pair object. If you create a single table object, you specify the primary key. If you create a table pair object, you specify the join condition. You can include a WHERE clause to validate a subset of the data.

           

          When you create a table object, the PowerCenter Integration Service stores the object in the Data Validation Option repository.

           

          Step 4. Create a validation test.

          After you create a table object, you can create a test based on the object. When you create the test, you choose the type of test that you want to run. You can choose an aggregate, set, or value test type. You configure test conditions based on the type of test that you choose.

           

          Step 5. Run the test.

          After you create a validation test, you can run it. When you run a validation test, the PowerCenter Integration Service creates the mapping and run-time objects in the Data Validation Option folder of the PowerCenter repository. It runs the mapping and loads the results into the Data Validation Option repository.

           

          Step 6. View the test results.

          After you run a test, you can view the summary of results in the Data Validation Client. You can see if the test passed or failed. The test fails if any row does not meet the validation condition. You can run reports from within the Data Validation Client. You can also view the session log from within the Data Validation Client.

           

          Best regards,

          Syed

          • 2. Re: Post validation tasks after informatica upgraded to 10.4
            Nico Heinze Guru

            In general you have to make sure that the output of all workflows are the same in both versions.

            And that your scheduling system (whichever you use) works the same way after the upgrade as before. Not to forget that you must check whether any command-line utilities you use (such as pmcmd for workflow execution or pmrep for e.g. deployment purposes) uses different command-line options (or XML structures in import control files) in 10.4 than in 10.1.1.

             

            Regards,

            Nico

            • 3. Re: Post validation tasks after informatica upgraded to 10.4
              Santosh Gade Seasoned Veteran

              I would do the following

               

              Modify the .profile file to edit the INFA_HOME and INFA_DOMAINS_FILE parameters. $PATH variable should be set correctly to reflect the informatica, oracle and Java entries. $LIBPATH/$LD_LIBRARY_PATH parameter should be checked as well.

               

               

              Modify the odbc.ini file to reflect the new odbc drivers.

               

               

              Ensure access to the infa_shared folder referred by $PMRootDir in the Integration services and change the isp/logs directory.

               

               

              Ensure any custom certificates/ini files you have are also updated