将参数用作Informatica映射的Web服务输入(Use parameter as web service input for Informatica mapping)

将参数用作Informatica映射的Web服务输入(Use parameter as web service input for Informatica mapping)

我有一个WCF Web服务，它将开始和结束日期作为输入，并返回一个记录集。 我想要做的是设置一个Informatica映射，为一周前和今天的日期创建变量。 这些用作Web服务消费者或Web服务的输入（作为源代码）（但以工作为准），但我不确定如何解决此问题。 我无法创建一个没有输入的表达式，也看不到如何将映射参数设置为输入。

我可以考虑的唯一两种方法是构建一个应用程序，该应用程序可以创建具有两个日期的平面文件，也可以构建将日期作为源提供的数据库对象。 我宁愿没有单独的外部来源来提供这些价值，但我想不出另一种方式。

I have a WCF web service that takes a start and end date as input, and returns a record set. What I'd like to do is setup an Informatica mapping that creates variables for the date from one week ago and today's date. These are used as input for the web service consumer or web service as a source (whichever will work), but I'm not sure how to go about this. I can't create an Expression with no inputs, and I don't see how to set a mapped parameter as input.

The only two ways I can think about doing this would be to either build an app that creates a flat file with both dates, or to build a database object that supplies the dates as a source. I'd rather not have a separate outside source to provide these values, but I can't think of another way.

最满意答案

如果在映射运行之前需要设置这些变量，请在工作流程中使用“ Assignment Task ，并use前变量分配”在映射运行之前设置映射的值。

There is no way to do this with the Informatica v9.6.1. A source has to be created in order to feed the web service. I ended up creating a dummy record with 1 field, using it as input, then disregarding the input and setting up variable output using an Expression transformation.