2 Replies Latest reply on Jun 21, 2013 8:35 AM by SH_INT

    Issue with DataSets in ODI

    SH_INT

      Hi,

       

      I have two datasets (each contain three tables joined together, different filter criteria in each dataset) in my ODI interface on which I perform the MINUS SET commad. The results from this are to be written to a file. When I run the pure SQL in a SQL editor I get the result set back I am expecting. However, when I run my ODI interface I get no results. When I look at the generated SQL all I have is a SQL statement based on a single table from my dataset with no reference to the joined tables and no reference to the 2nd dataset or MINUS command. ODI version is 11.1.1.6. Is there an issue with the dataset feature?