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?
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 is an expression transformation?
What do you mean by worklet?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is joiner change?
What are the different options available for update strategy?
What is union transformation in informatica?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is informatica etl tool?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How to open an older version of an object in the workspace?
When do you use sql override in a lookup transformation?
What is primary and backup node?
What are the mapping parameters and mapping variables?
Define update strategy?