Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 8146 Views
- Cognizant, emc2, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different components of powercenter?
Explain load alternative records / rows into multiple targets - informatica
What does refresh system mean, and what are its distinctive choice?
What is dimensional table?
What is a node in Informatica?
While migrating the data from one environment to another environment how would you manage the connections?
what is the size of your data warehousing?
What is a surrogate key?
How to elaborate powercenter integration service?
Define mapping and session?
Explain the tuning lookup transformation - informatica
What is powercenter on grid?
Is it possible to create multiple domains on a single Informatica server?
How to update or delete the rows in a target, which do not have key fields?
What is mapping debugger?
