Data Integration

Cascade:

- Cascade process involves taking values from various other prompts.

- The result is a single report.

- The result is used when a criteria is to be implemented.

Drill Through:

- Drill Through process is implemented when navigation from summary to detailed information.

- Drill Through has a parent and a child report.

- Data of another report can be seen based on the current details of data.

- Scheduling and executing the batch jobs.

- Configuring, starting and stopping the real-time services

- Adapters configuration and managing them.

- Repository usage, Job Server configuration.

- Access Server configuration.

- Batch job publishing.

- Real-time services publishing through web services.

- Data Integrator produces a row in the output data set for every value in the designated pivot column.

- More than one pivot column can be set as per the need of application’s data integration.

- Pivot Sequence Column – Data Integrator increments a sequence number for every row created from a pivot column.

- Non-Pivot column – The columns that need to appear in the target.

- Pivot Set – A group of pivot columns, unique data field and header column.

- Data Field Column – It contains the pivot data along with pivot columns values.

- Header Column – Lists the name of the columns.

- History Preserving is for providing new row in the target instead of updating the existing row.

- The columns are indicated for transforming the changes that are to be preserved.

- New rows are created when the value of certain column changes.

- Each of these rows is flagged as UPDATE.

- The UPDATE flag is applied for the input data set.