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
- 8289 Views
- Cognizant, emc2, I also Faced
- E-Mail Answers
Answer Posted / venubyna1
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 |
Post New Answer View All Answers
Can we create a node as a gateway node and the same node can be assigned to a grid?
What if the source is a flat-file?
How do you load unique records into one target table and duplicate records into a different target table?
What is enterprise data warehousing?
What is informatica powercenter repository?
What are the different components of powercenter?
Enlist the tasks for which source qualifier transformation is used.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is transformation?
What are the different types of olap? Give an example?
Enterprise data warehouse your projects phase by phase explain?
What are the new features of Power Center 5.0?
How to start a workflow using pmcmd command?
What is union transformation in informatica?
What is the use of code page?
