can u apply SCD2 on flat file tgt? if yes wat is the procedure?
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
scenario where i can use only concurrent execution of workflow.
How are indexes created after completing the load process?
Tell me about MD5 functions in informatica
Explain transaction control transformation in informatica
Differentiate between router and filter transformation?
What is data transformation manager process?
What is an expression transformation in informatica?
Where is metadata stored?
Is there any target staging area in informatica not staging area
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is mapplet in informatica?
How many types of sessions are there in informatica.please explain them?
Explain the aggregator transformation?
How might one distinguish in the case of mapping is right or not without associating session?
How do you update the records with or without using update strategy?