Built-In-Strategies:

• Extracting the joins with tables
• Detect cardinalities in joins
• Create DEFAULT classes and objects from the tables
• Objects - In this we can set how the objects to be displayed in the universe pane
• Joins - In this we can set how the joins between the tables has to be retrieved like matching COLUMN names or matching names etc.
• Tables - In this it will reads the table structure from the database.

The other strategies:

• Setting the number of rows to be retrieved - default 100
• The number of row retrieved from database
• The EXECUTION TIME of the query BASED on the number of minutes specified.
• The maximum size of the long text objects.

External Strategies: External strategies are declared in STG section of .PRM file. We can create the external strategy using either sql or flat file.

Built-In-Strategies:

The other strategies:

External Strategies: External strategies are declared in STG section of .PRM file. We can create the external strategy using either sql or flat file.