Hi in type2 dimension/flag current mapping there are three data flows i.e 1. data flow for new rows 2 .data flow for chnged row 3. data flow for updated changed row whats the differece between last two data flow thanks - girish gowda

Interview Candidate
Sep 15th, 2006
2
2315

Showing Answers 1 - 2 of 2 Answers

amolak singh

Jun 20th, 2007

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'.

Rambabu.Gali

Nov 26th, 2007

1.The first one for new rows.
2. Second one for updating the end date. (we will maintain the history in 3 ways 1. By date, 2. By Flag, 3. By Version).
3. Third flow if for inserting the updated row as a new row.