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.