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
- 8145 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 filelist concept in informatica
What are the types of presistent cache in look up tr.
State the limitations where we cannot use joiner in the mapping pipeline?
Can any one explain or sujjest some sites for scd mappings.Thank you
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
Which gives the more performance when compare to fixed width and delimited file ? and why?
why union is active transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What does refresh system mean, and what are its distinctive choice?
what is the difference between mapplet & stored procedure?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Can you generate reports in Informatcia?
Teradata 
