Checkpoint in SSIS allows the project to restart from the point of failure. Checkpoint file stores the information about the package execution, if the package run successfully the checkpoint file is deleted or else it will restart from the point of failure.
Late Arriving Dimension are unavoidable, to handle these we can create a dummy dimensions with natural/business key and keep the rest of the attributes as null or default. So when actual dimension arrives, the dummy dimension is updated with Type 1 change. This is also referred as Inferred Dimensions.
Explain what is SSIS? Mention what are the important components of SSIS package? Explain what is Solution Explorer in SSIS? Explain what does it mean by data flow in SSIS? Define what is “task” in SSIS? Explain what is SSIS package? List out different types of connection or files that support SSIS? Explain what is […]
In SSIS, a container is a logical grouping of tasks, and it allows to manage the scope of a task together. Types of containers in SSIS are Sequence container For loop container Foreach loop container Task host container