How to lool and check record existance

• Sunil Bansal

  Mr or Mrs. 500

  Points: 521

  More actions

  December 5, 2006 at 5:57 pm

  #118235

  Hello Guys,

  Now in the process I have to face another issue.

  After having the Merged data from 2 excel files in the Merge Join.

  I have to update this data in the database table.

  I have to update the existing records if need be, and also insert if there are new records in the databse table.

  How can I loop thru the records in the merged join I have.

  Or if any other way to keep the out put in some other place and then loop thru.

  I need to check if the record exits, then update else insert the record.

  Please reply with your Ideas.

   

  Thanks,

  Sunil

   

   

• Jambu Krishnamurthy

  SSCrazy

  Points: 2054

  More actions

  December 6, 2006 at 7:27 am

  #676208

  I would suggest a Multiphase Data Pump (Data Driven Query Task).

  And you can use the lookup feature for looking up for insertion/updation/deletion.

   

  If you nhave not done these, it may take a while to get the hang of it. But if you know them, it is all simple. If you need any more help, you can bug me

• Sunil Bansal

  Mr or Mrs. 500

  Points: 521

  More actions

  December 7, 2006 at 5:20 pm

  #676785

  Hello,

  I just have another table( you can say temp table).

  I first populate that table.

  Then by Execute SQl Task, have a script to update and insert the records in the final table.

  Thanks for suggestions.

   

  Regards

  Sunil