A stitch query is the name given to the type of query that IBM Cognos BI produces when a user creates a query that contains two or more fact tables. A stitch query consists of independent sub-queries for each fact that are then joined together on common dimensions. This joining process is done using an FULL OUTER JOIN to ensure no data from any fact sub-query is lost during the stitch.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!