July 28, 2014 at 1:19 am
Hi ,
I need some info. about the Insert and updating the Records from Oracle Table to SQL server table using the SSIS packages and Attunity as the Source. Let me tell you my requirement
I have got a table in Oracle DB which has got a 'S_ID' and many Columns and 'DATEM' columns
so now i want to insert the new records and update the Exsiting records based on the Datemodified(DATEM) column into my sql table from Oracle..
I know that this kind of requirement are already available in net when i googled but i am unable to understand what to do and what are steps and what are the columsn to compare .
Please suggest me the ssis package and what are the transformations and any comparison columns i need to refer ?
July 28, 2014 at 1:26 am
Guitar_player (7/28/2014)
Hi ,I need some info. about the Insert and updating the Records from Oracle Table to SQL server table using the SSIS packages and Attunity as the Source. Let me tell you my requirement
I have got a table in Oracle DB which has got a 'S_ID' and many Columns and 'DATEM' columns
so now i want to insert the new records and update the Exsiting records based on the Datemodified(DATEM) column into my sql table from Oracle..
I know that this kind of requirement are already available in net when i googled but i am unable to understand what to do and what are steps and what are the columsn to compare .
Please suggest me the ssis package and what are the transformations and any comparison columns i need to refer ?
Since you are indeed doing a full merge, I would suggest to use a staging table for the ORA recordset and a stored procedure with the MERGE statement.
😎
July 28, 2014 at 1:30 am
Actually i am inserting and updating into the Staging table only from Oracle and then we are building a Dimensional Data warehouse upon that ..
But here i am Inserting and updating the Staging table only which we are going to use further.. 🙂
July 28, 2014 at 5:24 am
Guitar_player (7/28/2014)
Actually i am inserting and updating into the Staging table only from Oracle and then we are building a Dimensional Data warehouse upon that ..But here i am Inserting and updating the Staging table only which we are going to use further.. 🙂
Quick questions
a. Is it a large table?
b. Are there many new and updated entries?
😎
July 28, 2014 at 5:28 am
For some Tables
Yes they are some Big Tables and for some other Tables the insert and update may be huge
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply