
General Notice: BOB is going to retire...please see details here. General Notice: No events within the next 45 days. |
Author |
Message |
reypiad Forum Member


Joined: 23 Mar 2012
       Posts: 4

|
Posted: Mon Feb 10, 2014 5:39 am Post subject: 0FI_GL_14 Extractor Delta Issue |
|
|
Hi All,
We've been getting duplicate rows errors whenever we get the delta of 0FI_GL_14 Extractor.
What's the correct way of designing a Data Flow for this type of Delta Extractor?
Your ideas and thoughts will be appreciated!
Thanks!
Rey Piad |
|
Back to top |
|
 |
Leigh Kennedy Principal Member


Joined: 16 Jan 2012
       Posts: 330 Location: Sydney, Australia

|
Posted: Mon Feb 10, 2014 4:50 pm Post subject: Re: 0FI_GL_14 Extractor Delta Issue |
|
|
Are the duplicates within the delta itself, of is it clashing with the contents destination table ?
If its the latter, you can fix it with a table comparison. If its the former, then it either:
1) You have the wrong keys defined, and its not really a duplicate or
2) The extractor is returning data out of sequence. I have this issue, but only with 2LIS extractors. If this is your issue, I have no solution for you. _________________ ___________________________________
Leigh Kennedy
www.isql.org |
|
Back to top |
|
 |
gaurav4jain Forum Member


Joined: 06 Feb 2017
  Posts: 1

|
Posted: Mon Feb 06, 2017 8:32 am Post subject: Re: 0FI_GL_14 Extractor Delta Issue |
|
|
Hi,
I am facing the same issue of duplicate entries when using extractor 0FI_GL_14 for delta load. Please let me know if you were able to fix the issue?
Regards
Gaurav |
|
Back to top |
|
 |
|
|