Official

Accepted

Unanswered

Relevance
Selected Relevance

Advanced Filters

Search Results (6)

Migration of data quality rules from informatica to Collibra

Hello friends, We are trying to migrate our data quality rules and assets from Informatica to Collibra.  Can somebody please help us to how effectively it can be done. We have large number of rules, so that manually recreating them will not be working. Thanks in advance Haz

Questions

23

0

0

DQ Audit Trail for Rule Changes

A prospective client asked a fine question regarding “auditing the change of the custom rules.” After some research and testing this, indeed we do have auditing of rule changes at this level of granularity: Audit columns: dataset = Any rule is associated with a Dataset. So this is the name of the

Questions

22

2

0

0

TO BE REVIEWED: DQ Rule Creation: Simple vs. Freeform vs. Native

Customer Question: “Please advise if this type of rule can be written as a Simple Rule, or must it be written as Freeform SQL or as a Native SQL rule?: BP_HIGH_IND is NULL AND BP_IND IS NULL AND ADDR_LINE3_TX is NOT NULL AND (length(ADDR_Line1_TX) > 40 or ADDR_LINE3_TX NOT rlike (’^[a-zA-Z0-9,#&a

Questions

64

0

0

0

REVIEWED-PENDING DOCUMENTATION: How can I use DQ to export the table rows where there were DQ rule breaks?

When using the Collibra DQ software, if there is a rule break, how can I export the table row which had the broken rule, so that I can go back and fix the problem in my data source? Answer: You will need to select the Link ID in the scope page, and this will allow you to export the row(s) where rule

Questions

38

0

0

0

REVIEWED-PENDING DOCUMENTATION: Collibra DQ Check for Longitude/Latitude

Question from a prospect was, can Collibra DQ automatically check the longitude and latitude values? Answer: We have two Collibra DQ out of the box semantic rules: LAT: ^(\\+|-)?(?:90(?:(?:\\.0{1,6})?)|(?:[0-9]|[1-8][0-9])(?:(?:\\.[0-9]{1,6})?))$ LNG: ^(\\+|-)?(?:180(?:(?:\\.0{1,6})?)|(?:[0-9]|[1-9]

Questions

26

1

0

0

Does a rule which references another DQ Dataset refresh that DQ Dataset?

Question: Given the following rule: select department from @PUBLIC.EMPLOYEES EXCEPT select department from @PUBLIC.REFERENCE_DEPT Will this rule when run cause the reference Dataset @PUBLIC.REFERENCE_DEPT to immediately run and refresh its contents? Answer: According to Eric Gerstner, yes it will a

Questions

10

1

0

0