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
- 8279 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
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is standalone command task?
Can we change Dynamic to Static or Persistent cache? If so what happens?
define galaxy repository in informatica
Parameter and variable differences
What is the use of transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How do you migrate data from one environment to another?
What is informatica? Why do we need it?
wat are deployement groups in informatica, how it will be used for developers
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the different options available for update strategy?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Did u used latest transformations of 8.6.0? for what?
What is the sequence generator transformation in informatica?
