Interested to Buy Any Domain ? << Click Here >> for more details...
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
- 3 Answers
- 26454 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / rajesh aitha
Yes, I can
Let’s go head implementation
Understanding: In SCD2 we have 3 steps
1. Identify new record and insert as new record
2. Identify Updates in target and insert it as new record
3. Update the updated records to makes end date as system date
Process of implementation:
Step1: Generate 3 files as described above
Step2: The file to update is available and we have surrogate key of each row as well , use a script to Fetch the surrogate key to separate temporary file, Delete these rows from main file and keep it as separate file with appended field Last updated date at extreme right side of the file
Step2: So here we have 2 new files created for with new records as inserts, 1 file with updates. Now keep adding these 3 files to the mail file one by one in sequence.
What do you think?
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
Which version configuration tool used in ur project?
Where do we use mapping variables in informatica?
Explain the pipeline partition with real time example?
Briefly define reusable transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How big was your fact table
Explain the tuning lookup transformation - informatica
difference between repository database and repository service?
Describe expression transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the Process to creating lookup transformation in informatica
How can we improve session performance in aggregator transformation?
What is sq transformation?
What is the procedure for creating independent data marts from informatica 7.1?
