1.What are the factors deciding whether to go for a full extract or incremental load?
2. If the end users are using the OLTP systems 24 hours a day – 7 days a week, how will you plan for the extraction?
3. How do you handle incremental updates in Informatica?
4. How do you identify a particular dimension as a slowly changing dimension?
5. What is a rapidly changing dimension? How will you handle it in Informatica?
2. If the end users are using the OLTP systems 24 hours a day – 7 days a week, how will you plan for the extraction?
3. How do you handle incremental updates in Informatica?
4. How do you identify a particular dimension as a slowly changing dimension?
5. What is a rapidly changing dimension? How will you handle it in Informatica?