I am trying to learn about SSIS and have no doubt about it.
I need to compare 2 tables. The table is in Sql Server, and the other is in Oracle.
Both tables will have the same layout as shown below:
Sql Server:
Id Amount
1 100
2 200
3 300
Oracle:
Id Amount
3 3000
2 2000
1 1000
These are just a few examples of records, since I have 24 million records in the source (12 million) and target (12 million) in some random order.
Challenge . I am trying to compare source and target data. Since there should always be 1 to 1 matches between the source and target data based on joining id column from source and targetand performing the comparison on Amount columnand saving the unmatch records in the sql server database, so I know what it Look up transformationwill do in this case.
But I have some doubts:
1) , * , 24 ? ?
2) ?
3) (i.e) , ? , 1 1 , ?
4) SSIS ?
-, , ?