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 are the different types of olap? Give an example?
What happens when a session fails and you click on recover?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Clarify the aggregator change?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Name the different lookup cache(s)?
How can we improve session performance in aggregator transformation?
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 are the tuning techniques you applied during your last project
What is a surrogate key?
What is aggregate cache in aggregator transformation?
How an expression transformation differs from aggregator transformation?
Explain the types of transformations?
lookup transformation with screenshots
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)