Skip navigation
Contact Us
1824 Views 5 Replies Latest reply: Nov 21, 2012 6:57 AM by Viral Raichura RSS
shiva jalabagari Novice 21 posts since
Jul 6, 2011
Currently Being Moderated

Nov 10, 2012 3:55 AM

LookUp on Target Table Insert Only New Records

Hi All,

 

Source : XML file  

Target : Oracle DB table

 

 

I have an XML file come daily with NEW/OLD records.

 

Requirement : We have to insert only new records into target(OracelDB table). Target maintain History of every day load(Append ).

 

 

If any record coming from Source which is already exist in Target ? Yes either we can Ignore nor Replace old record.

 

Ex:

 

Day 1

 

Source         

---------

Col1  Col2   Col3  Col3

1     a          b          c

2     c          d          e

3     n          h          y    

4     j           k          k

 

Target

-----------

Col1  Col2   Col3  Col3

1     a          b          c

2     c          d          e

3     n          h          y    

4     j           k          k

 

Day-2

 

Source

---------

Col1     Col2     Col3     Col4

5          a          b          c

6          c          j           j

7          j          k          k

4          j          k         k                =====>> This should not go to Target Coz , its already exist in Target.

 

Before thinking in a way to do it , below are the exceptions .....!!!

 

1) My target table do not have any unique column to look for .......!!

 

2) Even do not have any PK column.....  !!

 

In this case can anyone able to provide simplest way to do it ................?

 

thanks in advance

 

Shiva

More Like This

  • Retrieving data ...

Bookmarked By (0)