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
- 8419 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 |
Differentiate between mapping parameter and mapping variable?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
design of staging area?
How can we use mapping variables in informatica?
How you load distinct records into one target and duplicate records into another target?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
Limitation of REPLACESTR. Is there any character limitation to it.
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
Explain the tuning lookup transformation - informatica
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
What do you mean by filter transformation?
Teradata 
