Types of Strategies
Specify the several types of Strategies?
Expert
In Designer we may specify the two types of strategies:
a) External strategies
b) Built–in strategies
Built–in Strategies : Designer offers a number of default strategies that we may use. These are the strategies in order to extract the joins, detecting the cardinalities, and producing the default classes and objects. Options in order to indicate the default strategies are situated in the Database tab of the Options dialog box.
External Strategies : We may also produce our own strategies. These strategies are considered as the external strategies. Along with the external strategy, we may describe the exact way that objects and joins need to be extracted from database structure. The external strategy is generally specific to one RDBMS.
What are true statements regarding implicit cursors?
Explain the group by in select statement? Answer: Group by clause is utilized in Teradata to eliminate repetitive values in a column or group of columns, while we se
Write down some of the differences between the data query and the knowledge query.
State difference between Passive and Active transformation?
Specify different types of transformations available in the Informatica?
How can we handled are recursive relationships in a database design? Describe briefly?
What is meant by the term query subject?
Specify the chief components of the Transaction-based Systems?
Elucidate how many kinds of dimensions are accessible in the Informatica?
Provide a brief introduction of the term ‘Data warehousing ’?
18,76,764
1944017 Asked
3,689
Active Tutors
1432975
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!