Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Comparing Objects
  12. Managing Business Components
  13. Creating Cubes and Dimensions
  14. Using the Mapping Wizards
  15. Appendix A: Datatype Reference

Designer Guide

Designer Guide

Relational Source Definitions

Relational Source Definitions

You can import relational source definitions from database tables, views, and synonyms. When you import a source definition, you import the following source metadata:
  • Source name
  • Database location
  • Column names
  • Datatypes
  • Key constraints
When you import a source definition from a synonym, you might need to manually define the constraints in the definition.
After importing a relational source definition, you can optionally enter business names for the table and columns. You can also manually define key relationships, which can be logical relationships created in the repository that do not exist in the database.

0 COMMENTS

We’d like to hear from you!