Assume I have couple of source tables like Per_All_XXX_1, PER_ALL_XXX2_2,PER_XXXXX3_3,P_XYZ_4.
and My Target table Is a Dimension table as Customer with 100 and more columns.
Now I am facing incremental data load issue, in my one of source table does not have LastupdateDate column, So whenever some new row inserts or any updates into this table, Incremental run did not capture those records and missed those records.
Can you please let me know How I can load incremental data on each run of incremental load, without losing any row from any of source changes?
Please suggest me as valid solution to implement in real time. I had already seen posts on google.