Data Warehousing Community Forum
February 08, 2012, 11:40:49 pm

Pages: [1]   Go Down
  Print  
Author Topic: Mappings validation in Bulk  (Read 1529 times)
Allegra
DW Apprentice
**

Reputation: +17/-0
Offline Offline

Posts: 75



View Profile
« on: July 06, 2010, 03:46:36 pm »

Has anyone validated mappings (or) sessions in bulk.

Please let me know the method to achieve it..! Huh
Logged

@llegr@
what do you call an Ant with an AK47 ?
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: July 06, 2010, 11:12:51 pm »

Following are the steps to validate all objects in a folder:
 
1) Go to the Repository manager client
2) Create a query with parameter name and condition to retrieve the mappings in a folder as the following:

Code:
 folder = folder-name
  object type = mapping/session/workflow

3) Use the following Pmrep Execute query command to get persistent output file:

Code:
executequery -q <query_name> [-u <output_persistent_file_name>] [-a (append)]

4) You can choose to display the result or write the result to a persistentoutput file. If the query is successful, it returns the total number of qualifying records.
 
5) Use newly created persistent output file as a input file in the following pmrep validate command :

Code:
pmrep validate-i <persistent_input_file>}
[-p <output_option_types valid saved, skipped, save_failed, invalid_before, invalid_after, or all)>
[-u <persistent_output_file_name>] [-a (append)][-b (verbose)]

 
6) You can output the results to a persistent output file or standard output. It also displays a validation summary to stdout . The summary includes the number of valid objects, invalid objects and skipped objects.

PS - This is applicable to both versioned and non-versioned repository objects. You can also automate the validation by running this as a batch script inWindows or shell script in UNIX.
Logged

jimmymj
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 2



View Profile
« Reply #2 on: August 03, 2011, 05:00:45 pm »

Has anyone validated mappings (or) sessions in bulk.

Please let me know the method to achieve it..! Huh

~ bulk session validation ~

For bulk session or mapping validation in informatica, open workflow manager or PowerCenter Designer and create a query using query from Tools menu.
The query should be return the sessions or mappings which you want to validate. Run the query.

Select sessions from the query result, go to Tools menu in the query result window then select Validate... command.

The selected object will validate and you will get number of valid, not valid objects.

 Kiss
Logged

~jim
Pages: [1]   Go Up
  Print  
 
Jump to: