InterviewSolution
| 1. |
What Is The Difference Between Last Two Data Flow? |
|
Answer» When we are working with FLAG we can use only 2 filter transformations also but at the initial stage it will be better to go with 3 filters. Where we are using the FIRST Filter to insert the records for first TIME, In second Filter we are INSERTING the records but these records are with updated INFORMATION and in THIRD filter we are updating the records with surrogate key. This third filter records will be updated with our changed FLAG value 'ZERO'. Because we are identifying the current records with FLAG VALUES 'ONE'. When we are working with FLAG we can use only 2 filter transformations also but at the initial stage it will be better to go with 3 filters. Where we are using the FIRST Filter to insert the records for first time, In second Filter we are inserting the records but these records are with updated information and in third filter we are updating the records with surrogate key. This third filter records will be updated with our changed FLAG value 'ZERO'. Because we are identifying the current records with FLAG values 'ONE'. |
|