3 Replies Latest reply: Jul 18, 2013 2:54 AM by DecaXD RSS

    Problem in handling multiple source of Complex CSV files in ODI

    Anindya Gayen

      Hi,

       

      I have a requirement where I have multiple CSV files.

       

      In Details:

       

      when I have one CSV file I use the following syntax in JDBC URL in creation of Data Server under Complex file of Topology navigator.

       

      jdbc:snps:complexfile?f=C:\pqr\pqr.csv&d=C:\pqr\pqr.xsd&re=Root

       

       

      When there are multiple CSV files what would be the syntax as? will it be like

       

      jdbc:snps:complexfile?f=C:\pqr\*.csv&d=C:\pqr\pqr.xsd&re=Root (I am getting error as unexpected token * when I am using * and clicking on Test Connection Button).


      Please help..

       

      Thanks.