Command Reference > infacmd ps Command Reference > detectOrphanResults
  

detectOrphanResults

Detects profile results in the profiling warehouse that do not have an associated profile in the Model repository. When you delete a profile before you open it, the Developer tool or the Analyst tool removes the profile and its metadata from the Model repository. The action results in orphan profile results in the profiling warehouse. To detect the orphan profile results, you can run the infacmd ps detectOrphanResults command. To save the command output to a file, run the infacmd ps detectOrphanResults > <filename> command.
The infacmd ps detectOrphanResults command uses the following syntax:
detectOrphanResults

<-DomainName|-dn> domain_name

[<-Gateway|-hp> gateway_name]

[<-NodeName|-nn>] node_name

<-UserName|-un> user_name

<-Password|-pd> Password

[<-SecurityDomain|-sdn> security_domain]

<-MrsServiceName|-msn> MRS_name

<-DsServiceName|-dsn> data_integration_service_name

The following table describes infacmd ps detectOrphanResults options and arguments:
Option
Argument
Description
-DomainName
-dn
domain_name
Required. The name of the Informatica domain.
You can set the domain name with the -dn option or the environment variable INFA_DEFAULT_DOMAIN. If you set a domain name with both methods, the -dn option takes precedence.
-Gateway
-hp
gateway_name
Optional if you run the command from the Informatica installation \bin directory. Required if you run the command from another location.
The gateway node name.
Use the following syntax:
[Domain_Host]:[HTTP_Port]
-NodeName
-nn
node_name
Required. The name of the node where the Data Integration Service runs.
-UserName
-un
user_name
Required if the domain uses Native or LDAP authentication. User name to connect to the domain. You can set the user name with the -un option or the environment variable INFA_DEFAULT_DOMAIN_USER. If you set a user name with both methods, the -un option takes precedence.
Optional if the domain uses Kerberos authentication. To run the command with single sign-on, do not set the user name. If you set the user name, the command runs without single sign-on.
-Password
-pd
Password
Required if you specify the user name. Password for the user name. The password is case sensitive. You can set a password with the -pd option or the environment variable INFA_DEFAULT_DOMAIN_PASSWORD. If you set a password with both methods, the password set with the -pd option takes precedence.
-SecurityDomain
-sdn
security_domain
Required if the domain uses LDAP authentication. Optional if the domain uses native authentication or Kerberos authentication. Name of the security domain to which the domain user belongs. You can set a security domain with the -sdn option or the environment variable INFA_DEFAULT_SECURITY_DOMAIN. If you set a security domain name with both methods, the -sdn option takes precedence. The security domain name is case sensitive.
If the domain uses native or LDAP authentication, the default is Native. If the domain uses Kerberos authentication, the default is the LDAP security domain created during installation. The name of the security domain is the same as the user realm specified during installation.
-MrsServiceName
-msn
MRS_name
Required. The Model Repository Service name.
-DsServiceName
-dsn
data_integration_service_name
Required. The Data Integration Service name