Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Data Updates

Go down

Data Updates Empty Data Updates

Post  Balas Mon Jul 23, 2012 1:17 pm

Please through your views on the below Issue-

There is a Emp table in the DB. Every day the file will be getting updated. Once the data in the Emp table gets updated, the table contains only updated data. For few columns if there might be no updations based on the source data. The Issue is we needs to find a way which tells us which column value got updated.



Update Emp_Table
from Emp_Table A, Emp_source B
where A.Emp_ID=B.Emp_ID

Note: One thing needs note is some times Emp_source may comes with 4 to 5 days of updates with a date column. Every change needs to be captured like, which columns are getting updated. After Emp_Table gets updated, this table contains only one record per Emp_ID.

Hopes this will be little tricky. Help me with sample script.

Thanks in Advance.



Posts : 11
Join date : 2012-04-26

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum