on 01-09-2015 2:15 PM
Hi,
The query transform does not seem to have any fields. You should atleast have the field "surrogate_key" defined in the Query transform with the same datatype definition as the field surrogate_key field in table IQ_DS.dba.IQ_VENDEDORES.
kind regards
Raghu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Did you open the dataflow from the local object library directly or did you open the dataflow within the job where the global variables are declared? If you validate the job that has the global variables with the dataflow in it, you wont get these errors. If however you opened the dataflow on it own from the local object library, the validation will throw these errors.
Also, if the query is going to connect to the key_generation transform, then it is better to initialise the column surrogate_key to null instead of value 0.
kind regards
Raghu
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.