SQL Power Software Forum

Hi All,
I need some calrifications on DQGuru. Can anyone please help me in addressing this.

1) How to include "Business Rules" in DQGuru cleansing project. Eg of Business Rule is - I have a three columns in a table --> Status, Installation date, Disconnected date.

If my status is "Open" my Disconnected date should be null, else if my status is "Closed" my Disconnected date should be less than sysdate, else if status is "WIP" my Installation date should be less than sysdate.

2) Is it possible to create a "User Defined Transformer" in DQGuru? or we have only options to use the inbuilt transformers ?

3) Is it possible to include multiple source tables in the same transformer in a cleansing project?

4) Does the Address Database for countries other than canada are free of cost?

5) For a cleansing project, if a table doesnt have a unique index cant we use it?

Please help me in addressing these queries.

Thanks in Advance,
Ram Mohan T