Hi ,
My requirement is to read data from one SQL server instance and load to a different SQL server instance.
I was able to read data using DBQuery function and writing the output to a file.
But when i tried assign the same data to retrieved using DBQuery and assign to type tree generated using DB Table . the map compilation is failing
Output argument of rule does not match output type:
Red Arrow type Tree is failing
Blue Arrow type Tree is failing
How can i parse the data returned using select query with the data base table type tree.
I verified all the columns in the Type tree and sequence of the columns in select query all are matching.
Note:- i tried to write data generated using type tree 1( DbQuery) to a file and tried to parse the file with a Input card using same database table type tree it is working, but when i tried to assign to the type free directly it is failing.
------------------------------
Narendra Chimakurthi
------------------------------
#DataExchange#IBMSterlingTransformationExtender