In SCD type 2 if we had select date range. then suppose we had inserted today&#

In SCD type 2 if we had select date range.
then suppose we had inserted today's date(eq. date is 30 aug
2010) then start date will be today's date(30 aug 2010)
what will be the end date,we cant leave it blank?

Question Posted / minisweet85

2 Answers
7152 Views
Cognizant, emc2, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date ..

Answer / cbr

In SCD type 2 effective date approach the target table
structure should have kay column, ee_start_date,
eff_end_date and source columns.

1. eff_start_date will be "sysdate"
2. eff_end_date will be "future date"

ex: 01-01-3000(this is what the future date means)

i hope this will help you

Is This Answer Correct ?

1 Yes

0 No

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date ..

Answer / venubyna1

when ll we insert the data into target the systam date
insert into start date and in end date null
tomarrow we insert 50 rec into target table in that 25
update 25 new.
update rec inserting as a new rec(target table contain 50
rec and update as insert means 25 rec inserting from 51)

Is This Answer Correct ?

0 Yes

2 No

Post New Answer