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
- 8295 Views
- Cognizant, emc2, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
when ll we insert the data into target the systam date
insert into start date and in end date null
tomarrow we insert 50 rec into target table in that 25
update 25 new.
update rec inserting as a new rec(target table contain 50
rec and update as insert means 25 rec inserting from 51)
| Is This Answer Correct ? | 0 Yes | 2 No |
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
whatis the default data driven operation in informatica
Which is the t/r that builts only single cache memory?
how many session run unix environment what command using ?
What is an Integration service in Informatica?
guys which is the best institute in banglore to learn informatica??
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What is polling in informatica ?
what is parameter file?
Differentiate between joiner and lookup transformation?
How identifying bottlenecks in various components of informatica and resolving them?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Teradata 
