在Informatica存储过程调用中使用映射参数 [英] Using mapping parameter in an Informatica stored procedure call

问题描述

我正在使用存储过程作为Informatica映射中的源，并且在源限定符中将SQL查询定义为

I am using a stored procedure as a source in my Informatica mapping, and I have defined the SQL query in the source qualifier as

exec dbo.GET_ATTRIBUTES($$fromDate, $$toDate)

其中$$fromDate和$$toDate是我在参数文件中定义的映射参数.我尝试了许多不同的方法来解决这个问题，但是似乎都没有用，因为SQL查询无法通过验证.

where $$fromDate and $$toDate are mapping parameters I have defined in a parameter file. I have tried a number of different ways of going about this and none seem to work, as the SQL query fails to validate.

所以，我的问题可以归结为这一点，有没有一种方法可以在传递两个映射参数的同时调用存储过程?

So, my question boils down to this, is there a way to call a stored procedure while passing in two mapping parameters?

预先感谢

推荐答案

我实际上弄清楚了我的问题所在.事实证明，当我定义映射参数时，已将IsExprVar字段设置为TRUE.当我将其设置为FALSE时，可以在源限定符的SQL查询字段中调用它时将参数传递给存储过程.

I actually figured out what my issue was. It turns out that when I defined the mapping parameters I had set the IsExprVar field to TRUE. When I set it to FALSE I was able to pass the parameters to the stored procedure when calling it in the SQL query field of the source qualifier.

这篇关于在Informatica存储过程调用中使用映射参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！