Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to define data validation business rules in talend.
Right now I define all comparsion rules in the tmap, but now i have to put all rules in more then 100 columns which is not preferable in tmap.
Because it will difficult if any one of the rule will update in future so maintain those things will difficult in tmap.
Is any another solution or component there in talend like MDS where we can define business or conversion rules in a separate enties.
Thank you for reply.
Actually I have to compare my source data to target data with some business rules.
I have to validate that all source data are properly converted and transformed according to the business rules and uploaded successfully in target location.
It's just like data reconciliation with some business rules.
Properly converted -> datatype and formatting
Business rules -> formula, (non) equal, bigger, smaller, between and is matched with a record containing reference values.
Show us an example please?
- How many lookup records? How do you match is it 1:1 or 1:n ?
- Is it multicolumn validation like column combinations colA & colB -> match busrulCol X -> res(colA*colB) <= 113
Elaborate please?!?
Business Rules means compare(table a and table b) column_a.1 to column_b.1 and when column_a.1 ="A" then column_b.3="true/yes".
This kind of business rules i have to mention for 100+ columns.
Some field are directly validate means string to string like source values are properly loaded into the target location or not?
@Dijke wrote:
Properly converted -> datatype and formatting
Business rules -> formula, (non) equal, bigger, smaller, between and is matched with a record containing reference values.
Show us an example please?
- How many lookup records? How do you match is it 1:1 or 1:n ?
- Is it multicolumn validation like column combinations colA & colB -> match busrulCol X -> res(colA*colB) <= 113
Elaborate please?!?
Is any way in Talend like all business rules i will define in some user interface URL link or dashboard.
MDS have this functionality that we can create some business specific business rules and show into the user interface URL.