How do object become impacted/invalid while migration and how can we re validate them?

How can we roll back a deployment group?
November 1, 2016
Which ODBC driver need to be selected in order to use SQL Server 2014 source System?
November 4, 2016
Show all

How do object become impacted/invalid while migration and how can we re validate them?

There are multiple scenarios in which an object can become impacted/invalidated based on the changes done to the existing code for any of the objects.

  • Sources
  • Targets
  • Transformations
  • Mappings
  • Mapplets
  • Sessions
  • Tasks
  • Workflows
  • Worklets
  • User-definedfunctions
  • Sessionconfigurations
  • Schedulers
  • Cubes
  • Dimensions

If you are using deployment groups, the validation will be done with in the steps.

If you have automated the deployment using the BAT Scripts or Shell scripts then you can use the ‘validate’ command at the end of the script to run the validation for all the objects.

If you need to validate the complete folder then you can do it using the below steps in the Repository Manager.

  • Connect to the folder, where the validation should happen
  • Expand the Workflows folder
  • Select all the workflows in the folder. Yes, it is possible to do a multi-select in Repository manager
  • Right click and select validate
  • You would get the list of objects valid and the ones which are invalid

The other option is the wizard which pops up when you do the copy paste of the folders using the Edit menu. At the end of the wizard, you will have the option to select the validation option.

Business Intelligence Consultant and Trainer with 13+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies. Extensively worked on all facets of data warehousing including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP. Has worked on broad range of business verticals and hold exceptional expertise on various ETL tools like Informatica Powercenter, SSIS, ODI and IDQ, Data Virtualization, DVO, MDM.

Leave a Reply

Your email address will not be published. Required fields are marked *