如何在Informatica中设置截断错误 [英] how to set Error on truncation in informatica

问题描述

我只是informatica的新手，我想设置一个数据加载以处理错误检查.

I'm just new in the informatica and I want to set a data loading that will handle error checking.

例如，我现在在Recepction表中具有char(1)数据类型，在我的源文件中，我有多个char，但是informatica正在加载数据，并且在接收表中将其截断.

E.g I have char(1) data type in the Recepction Table now, in my source I have more than 1 char but informatica is loading the data and it is being truncated in the reception table.

我只想配置从源到接收发生截断时会话将失败的加载.

I just want configure the loading that my session will fail if there is truncation happen from source to reception.

推荐答案

默认情况下，值被截断时，会记录一条警告.如果要将截断作为错误处理，请在目标定义中选择选项Reject Truncated/Overflowed rows.

By default, when a value is truncated, a warning is logged. If you want to treat truncation as an error, select the option Reject Truncated/Overflowed rows in the target definition.

如果拒绝有问题的行还不够，您可以通过将非严重错误阈值设置为1(选项Stop on errors)，配置会话失败.

If rejecting the problematic rows is not enough, you can configure the session to fail by setting the non-fatal error threshold to 1 (option Stop on errors).

如果您需要仅监视选定的列，请对每个列使用以下表达式:

If you need to monitor only selected columns, use the following expression for each of them:

out_OneCharColumn = IIF(LEN(in_OneCharColumn) > 1
                      , ABORT('Source value would be truncated')
                      , in_OneCharColumn)

更多信息:如何在Informatica PowerCenter中使用错误处理选项和技术

这篇关于如何在Informatica中设置截断错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！