Need help in joining two tables in sql server and copy result to oracle database

[mboss1649680202]

hi,

I have two tables in sql server. I need to join this two tables in copy the result to oracle database table.

I am using below query and created a view based on below query.

select 

a.empId,empcode,empname,branch_names,dept_names,

CONVERT(VARCHAR(10), DateOFFICE, 101) as DateOffice,

CONVERT(VARCHAR(5),In1,108) as In1,

CONVERT(VARCHAR(5),OUT2,108) as OUT2

from AHome.dbo.Tran_Attendance a

inner join AHome.dbo.Mst_Employee b

on a.empid=b.empid

where In1 is not null or OUT2 is not null

order by empID,DateOFFICE;

create view biometric_attendance as 

select 

a.empId,empcode,empname,branch_names,dept_names,

CONVERT(VARCHAR(10), DateOFFICE, 101) as DateOffice,

CONVERT(VARCHAR(5),In1,108) as In1,

CONVERT(VARCHAR(5),OUT2,108) as OUT2

from AHome.dbo.Tran_Attendance a

inner join AHome.dbo.Mst_Employee b

on a.empid=b.empid

where In1 is not null or OUT2 is not null;

[Anonymous]

How are you wanting to use Talend here? You can use your select query to return the data and send it to Oracle. You'd need to use a tDBInput component to bring the data in (using that query) from SQL Server, then use a tDBOutput component to load into Oracle (you can also create your table if it doesn't exist with this. Creating your view you can do, but it will probably less work to just run that code in your DB.....unless you need it to be dynamic. In which case you can dynamically build your view script and then use a tDBRow to send it to the DB.