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
- 7176 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 |
Explain what is informatica metadata and where is it stored?
How can we handle two sessions in informatica?
Define Pmrep command?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
How to create Target definition for flat files?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What do you mean by filter transformation?
Target increases every day even though no new record was inserted
What is the Rank index port in Rank transformation?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What are the types of metadata that stores in repository?
Teradata 
