can u apply SCD2 on flat file tgt? if yes wat is the procedure?

Question Posted / aruna1105

3 Answers
24372 Views
Deloitte, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can u apply SCD2 on flat file tgt? if yes wat is the procedure?..

Answer / subhash

No, you can't apply SCD2 on flat files.

Is This Answer Correct ?

35 Yes

6 No

can u apply SCD2 on flat file tgt? if yes wat is the procedure?..

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

can u apply SCD2 on flat file tgt? if yes wat is the procedure?..

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

Post New Answer