Check if the record already exist.

oldforum

• July 16, 2007 00:00

• Answered

Follow

Hello, i'm new in cloverETL, i would like to ask if is't possible to check if the record is already exist in the database? thnx...

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  Yes, it is possible. Consider using some of join components. What do you exactly want to do?
  
  OtaSanek
• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  Hi, here is the scenario. I have a database(db1) which will bhe migrated to a New Database(db2).. these databases have different structures... For now, i can migrate data from db1 to db2 but some of the tables in db2 contains records already. when i try to migrate data from the table which has records, an error occurs(Unique constraint). thats why i want to check first if the record that will be migrated to db2 is already exist... is it possible??? thnx...

Please sign in to leave a comment.