Environment: Designer/Job Engine: 14.2.7.1156
Repository: 14.2.7.000
Back end: Source: SQL Server 2014
Target : Oracle 11g
Hello gurus,
I am trying to create ETL which preserves History on target table.
I referred how to use History Preserving Transform - SAP Community
somehow target table fetches more records compare to source table.
I am attaching document with clear screenshots of my transformation, source data and output data for first load, second load and third load.
Please guide me where my ETL transformation is wrong.
Thanks in advance.
ETL flow.zip (401.0 KB)
kumarbo7 (BOB member since 2007-07-12)