Explain in type2 dimension/flag current mapping there are three data flows i.e
1. data flow for new rows
2 .data flow for changed row
3. data flow for updated changed row
whats the difference between last two data flow?
Submitted by: AdministratorWhen 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'.
Submitted by: Administrator
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'.
Submitted by: Administrator
Read Online Programming Concepts Job Interview Questions And Answers
Top Programming Concepts Questions
☺ | Explain how Search engines work? |
☺ | Explain what is port? what is HTTP port, FTP port, Telnet port and others? |
☺ | What is the client business process in electronic industry (in mySAP CRM)? |
☺ | Explain how to get 1,4,7,10.....rows from a table? |
☺ | Write an O(log2(N)) algorithm to find X^N? |
Top Coding/Programming Categories
☺ | Python Interview Questions. |
☺ | OOP Interview Questions. |
☺ | Software engineering Interview Questions. |
☺ | PHP Interview Questions. |
☺ | VBA (Visual Basic for Applications) Interview Questions. |