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
- 8147 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
What is meant by LDAP users?
What is status code in informatica?
Enlist some properties of sessions.
On which transformations you created partitions in your project?
How can informatica be used for an organization?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What do think which one is the better joiner or look up?
How to update a particular record in target with out running whole workflow?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is sequence generator transformation in informatica?
Define Pmrep command?
What are ETL Tools?
What are junk dimensions?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the benefit of session partitioning?
