Informatica help

Informatica help and metadata report query

DBM Constraints for a Table

Informatica Database Management Constraints for a Table report

Lists Database repository constraints, such as Unique Key, Primary Key, Foreign Key, and Rule constraints, by the table for which the constraint is defined. It also provides the columns that participate in each constraint.


Click on the text to copy the query report to your clipboard.


select "TABLE_NAME",
"CONSTRAINT_TYPE",
"COLUMN_NAME",
"LX_LOCATION",
"CONSTRAINT_NAME",
"REPOSITORY_NAME",
"SCHEMA_NAME"
from (SELECT  DISTINCT ODS_IMA_ELEMENT.REPOSITORY_NAME as REPOSITORY_NAME,  ODS_IMA_PARENT_ELEMENT.ELEMENT_NAME as SCHEMA_NAME,  ODS_CHILD_LVL2_ELMT.ELEMENT_NAME as CONSTRAINT_NAME ,  ODS_CHILD_LVL2_ELMT.CLASS_TYPE as CONSTRAINT_TYPE ,  ODS_IMA_ELEMENT.ELEMENT_NAME as TABLE_NAME ,  ODS_IMA_CHILD_ELEMENT.ELEMENT_NAME as COLUMN_NAME ,  ODS_IMA_CHILD_ELEMENT.NAME_PATH as LX_LOCATION FROM  IMA_ELMNT_ASSOC ODS_IMA_ELMNT_ASSOC,  IMA_ELEMENT ODS_IMA_PARENT_ELEMENT,  IMA_ELEMENT ODS_IMA_ELEMENT,  IMA_ELMNT_ASSOC ODS_CHILD_LVL2_ASOC,  IMA_ELEMENT ODS_CHILD_LVL2_ELMT,  IMA_ELMNT_ASSOC ODS_IMA_CHILD_ELMNT_ASSOC,  IMA_ELEMENT ODS_IMA_CHILD_ELEMENT,  IMA_ELMNT_ATTR ODS_CHILD_LVL2_ATTR,  IMA_ELMNT_ATTR ODS_IMA_CHILD_ELMNT_ATTR  WHERE  (ODS_IMA_ELMNT_ASSOC.FROM_ELEMENT_UID = ODS_IMA_PARENT_ELEMENT.ELEMENT_UID   AND  ODS_IMA_ELMNT_ASSOC.TO_ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID AND  ODS_CHILD_LVL2_ASOC.TO_ELEMENT_UID = ODS_CHILD_LVL2_ELMT.ELEMENT_UID AND  ODS_IMA_CHILD_ELMNT_ASSOC.TO_ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID   AND  ODS_CHILD_LVL2_ASOC.FROM_ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID AND  ODS_IMA_CHILD_ELMNT_ASSOC.FROM_ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID AND  ODS_CHILD_LVL2_ATTR.ELEMENT_UID = ODS_CHILD_LVL2_ELMT.ELEMENT_UID AND  ODS_IMA_CHILD_ELMNT_ATTR.ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID)   AND  (ODS_IMA_PARENT_ELEMENT.PRODUCT_TYPE = 'Database Management' AND  ODS_IMA_ELEMENT.CLASS_TYPE IN ('Table',  'SnapshotTable') AND  ODS_IMA_CHILD_ELEMENT.CLASS_TYPE = 'Column' AND  ODS_IMA_CHILD_ELMNT_ATTR.CLASS_ATTR_NAME = 'name' AND  ODS_IMA_PARENT_ELEMENT.CLASS_TYPE IN ('Schema',  'User',  'Database') AND  ODS_CHILD_LVL2_ELMT.CLASS_TYPE IN ('CheckConstraint',  'ForeignKey',  'PrimaryKeyConstraint',  'UniqueConstraint',  'NotNullConstraint') AND  ODS_CHILD_LVL2_ATTR.CLASS_ATTR_NAME = 'name' AND  ODS_IMA_ELEMENT.DELETED_FLAG LIKE '%N%' )) "query"
order by "REPOSITORY_NAME", "SCHEMA_NAME"

2 comments to “DBM Constraints for a Table”

You can leave a reply or Trackback this post.
  1. yearlong - May 19, 2017 Reply

    so is those stats good to use ? and would you put that on your novus ?

  2. nissim229 - May 28, 2017 Reply

    Not sure i understands your question

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast