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
- 7422 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
How to create Target definition for flat files?
What is difference between a gateway node and worker node?
How can we use batches?
Why union transformation is an active transformation?
What is a router transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Difference between Target-based loading and constraint-based loading?
What is olap (on-line analytical processing?
What is sequence generator transformation in informatica?
Briefly define reusable transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How to update a particular record in target with out running whole workflow?
what is mean by complex business rule ?
What are the differences between oltp and olap?
