Dears,
I need to generate a custom warning from the transformer stage if the length of a certain column has been minimized by mistake. For example, if the column at the data source is Varchar with length 50 and at it's transferred through transformer stage as Varchar with length 10. I found out that transformer stage is not generating any warning in such case. For me, it's important that I can guarantee that data won't be truncated through ETL.
Can I do this?
Regards.
Custom Warning Generation for Transformer Stage
Moderators: chulett, rschirm, roy
You can declare a transform stage output link as "rejects" which triggers a warning in the log, so if you redirect your truncated string records using a constraint you will get warnings in your log. This would be easier than calling the c++ equivalent of DSLogWarn() through a custom buildop in your transform stage.
ArndW,
my purpose is not to reject these truncated string records, I only want to generate a log warning if they're truncated to pay attention. Finally can I find a project level solution not on the level of transformer stage or job level because I currently have more than one thousand jobs.
Regards.
my purpose is not to reject these truncated string records, I only want to generate a log warning if they're truncated to pay attention. Finally can I find a project level solution not on the level of transformer stage or job level because I currently have more than one thousand jobs.
Regards.
ArndW,
my purpose is not to reject these truncated string records, I only want to generate a log warning if they're truncated to pay attention. Finally can I find a project level solution not on the level of transformer stage or job level because I currently have more than one thousand jobs.
Regards.
my purpose is not to reject these truncated string records, I only want to generate a log warning if they're truncated to pay attention. Finally can I find a project level solution not on the level of transformer stage or job level because I currently have more than one thousand jobs.
Regards.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am