Hi i have a job designed for scd2,in the target i have 2 tables historical and current table.My question is how to move records from current table to histotrical table my client wanted to do this weekly once.
Help would be appriciated a lot.
How to load current table records to historical table in tgt
Moderators: chulett, rschirm, roy
Re: How to load current table records to historical table in
what is your target table structure? What are the columns used for identifying a history record ? Current Indicator.. Date Columns ?ashoks99 wrote:Hi i have a job designed for scd2,in the target i have 2 tables historical and current table.My question is how to move records from current table to histotrical table my client wanted to do this weekly once.
Help would be appriciated a lot.
We definitely need more info, as Havoc said. I am doing similar things, but would need to know general table layout structure to see how you are doing it. The way I do it now is to populate the additional fields I use for historical tracking and current row recognition during the transfer process, then everything is an insert marking the most current row with a flag.
Bestest!
Bestest!
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
Thans for replay i have some information
In the target i have the following fields customer_ID,cust_state,Record_eft_dt and current_recoard_indicator so
if an update record comes then the fields Record_eft_dt should be with the updated date and the current_recoard_indicator should be "Y" here if the current_recoard_indicator already "Y" then it should be "N".
I hope its good information.Thanks,
if an update record comes then the fields Record_eft_dt should be with the updated date and the current_recoard_indicator should be "Y" here if the current_recoard_indicator already "Y" then it should be "N".
I hope its good information.Thanks,
Thans for replay i have some information
In the target i have the following fields customer_ID,cust_state,Record_eft_dt and current_recoard_indicator so
if an update record comes then the fields Record_eft_dt should be with the updated date and the current_recoard_indicator should be "Y" here if the current_recoard_indicator already "Y" then it should be "N".
I hope its good information.Thanks,
if an update record comes then the fields Record_eft_dt should be with the updated date and the current_recoard_indicator should be "Y" here if the current_recoard_indicator already "Y" then it should be "N".
I hope its good information.Thanks,
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: