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
- 26105 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guddu kumar mehra
We can not update a record in a flat file as we need a Key column to update the record but in flat file we can not have a key column.
So we can not implement SCD type 2 on flat files.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / 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 |
Different circumstance which drives informatica server to expel records?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
What is the difference between informatica 7.0 and 8.0?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
What is DR strategy for Informatica project?
Differentiate between Load Manager and DTM?
what is the command to get the list of files in a directory in unix?
How you can differentiate between connected lookup and unconnected lookup?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
What is target load order?
What is factless fact schema?
What is the function of look up transformation?
Teradata 
