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
- 7420 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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
can u any challenge your project?
Define enterprise data warehousing?
Explain sessions?
Explain scd type 3 through mapping.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
EXL informatica Questions
what is unit testing?tell me proceedure
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is rank transform?
write a query to retrieve the latest records from the table sorted by version(scd)
How do you update the records with or without using update strategy?
What is meant by incremental aggregation?
Briefly define a session task?
What will be the approach?
