Is there any way that we can do incremental loading if both source and target are flat files?
Can any one respond to this please?
Printable View
Is there any way that we can do incremental loading if both source and target are flat files?
Can any one respond to this please?
Yes you can always do incremental load no matter your target and source are flat files are not. But make sure to check the [COLOR="Blue"][B]Append if Exists[/B][/COLOR] in session properties in mappings tab for target. And one more thing, if you are appending header to output target table it gets appended for first load, for next load only data gets appended.