Hi All,
I wanted to try an approach to transfer the data from one of my table oracle DB to a table in SQL Server DB.
i tried the approach of using 2 Query Database SmartServices. One is to Select the values from the Oracle DB table(Query Database 1), and the other is to insert the value in SQL Data Base table(Query Database 2).
Oracle DB table contains the value below:
SQL STATEMENT USED in QUERY DATABASE SMART SERVICE: (Select ID, FIRSTNAME, LASTNAME, TITLE FROM EMPLOYEE)
After executing the process Model to load the same data to SQL Server table, SQL Server DB table becomes,
SQL STATEMENT USED in QUERY DATABASE SMART SERVICE: (INSERT INTO EMP VALUES (ac!ID, ac!FIRSTNAME, ac!LASTNAME, ac!TITLE)
The value are populating in the single row not in different row as in Oracle DB.
Can anyone help me on this?
Discussion posts and replies are publicly visible
I would suggest to store the data returned from Oracle in a pv then format the data in a CDT format depending on in what format data is returned from Oracle.Then write data from this CDT to the SQL DB. In other words, you need to insert data row wise rather than column wise.