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
- 8288 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
How you can differentiate between connected lookup and unconnected lookup?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Could you explain what is enterprise data warehouse?
What are the performance considerations when working with aggregator transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
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.
Briefly describe lookup transformation?
Enlist some properties of sessions.
Explain lookup transformation is active in informatica
What is a repository manager?
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain target update override in informatica
Define filter transformation?
What is the difference between a repository server and a powerhouse?
Explian the Process of deployment groups in informatica
