- Home
- Informatica Tutorial
- Manually Creating a Source Definition - Informatica
Manually Creating a Source Definition - Informatica
Interview Questions
Practice Test
Pragnyameter Exam
All Tutorials
Job SearchYou can manually create a source definition.
To create a source definition:
- In the Source Analyzer, click Sources > Create.
- Enter the name for the source, the database name, and database type.
- Click Create.
- Click Done when you are finished creating source definitions.
- Configure the source definition.
An empty table structure appears in the workspace. (It may be covered by the dialog box.) The new source table also appears within the Navigator window.
The source definition is saved to the repository. You can now use the source definition in a mapping. You can also create a source table based on this definition in the source database.
|
|
Informatica Related Tutorials |
|
|---|---|
| Teradata Tutorial | OBIEE Tutorial |
Informatica Related Practice Tests |
|
|---|---|
| Informatica Practice Tests | Teradata Practice Tests |
| OBIEE Practice Tests |
Informatica Tutorial
- Viewing Data Lineage Overview
- Configuring Designer Options
- Using Toolbars
- Adding Custom Tools
- Navigating The Workspace
- Designer Tasks
- Previewing Data
- Working With Metadata Extensions
- Using Business Names
- Using Business Documentation
- Viewing Mapplet And Mapping Reports
- Source Definitions Overview
- Working With Relational Sources
- Working With Cobol Sources
- Components In A Cobol Source File
- Configuring Cobol Source Definitions
- Importing A Microsoft Excel Source Definition
- Manually Creating a Source Definition
- Troubleshooting Sources
- Target Definitions Overview
- Importing Flat Files
- Editing Flat File Definitions
- Formatting Flat File Columns
- Working With File Lists
- Working With Shift-sensitive Flat Files
- Working With Multibyte Data In Fixed-width Targets
- Troubleshooting Flat Files
- Working With Targets Overview
- Importing A Target Definition
- Creating A Target Definition From A Source Definition
- Creating A Target Definition From A Transformation
- Manually Creating A Target Definition
- Maintaining Relational Target Definitions
- Creating A Target Table
- Troubleshooting Targets
- Using The Designer Overview
- Working With Mappings
- Linking Ports
- Propagating Port Attributes
- Working With Sources In A Mapping
- Working With Relational Sources In A Mapping
- Working With Transformations In A Mapping
- Working With Mapplets In A Mapping
- Working With Targets In A Mapping
- Creating Target Files By Transaction
- Working With Relational Targets In A Mapping
- Validating A Mapping
- Using The Workflow Generation Wizard
- Troubleshooting Mappings
- Mapplets Overview
- Understanding Mapplet Input And Output
- Using The Mapplet Designer
- Using Mapplets In Mappings
- Rules And Guidelines For Mapplets
- Tips For Mapplets
- Mapping Parameters And Variables Overview
- Mapping Parameters
- Mapping Variables
- Defining Expression Strings In Parameter Files
- Tips For Mapping Parameters And Variables
- Troubleshooting Mapping Parameters And Variables
- Working With User-defined Functions Overview
- Creating User-defined Functions
- Managing User-defined Functions
- Creating Expressions With User-defined Functions
- Debugger Session Types
- Creating Breakpoints
- Configuring The Debugger
- Running The Debugger
- Monitoring The Debugger
- Modifying Data
- Evaluating Expressions
- Copying Breakpoint Information And Configuration
- Troubleshooting The Debugger
- Creating Cubes And Dimensions Overview
- Configuring Data Lineage Access
- Running Data Lineage From The Designer
- Data Lineage Example
- Comparing Objects Overview
- Comparing Sources, Targets, And Transformations
- Comparing Mappings And Mapplets
- Managing Business Components And Directories Overview
- Managing Business Components And Directories
- Multidimensional Metadata
- Creating A Dimension
- Creating A Cube
- Editing A Cube
- Editing A Dimension
- Deleting A Cube Or Dimension
- Opening And Closing A Cube
- Viewing Metadata For Cubes And Dimensions
- Tips For Cubes And Dimensions
- Maintaining Star Schemas
- Understanding The Mapping Wizards
- Creating A Pass-through Mapping
- Creating A Slowly Growing Target Mapping
- Creating A Type 1 Dimension Mapping
- Creating A Type 2 Dimension/version Data Mapping
- Creating A Type 2 Dimension/flag Current Mapping
- Creating A Type 2 Dimension/effective Date Range Mapping
- Creating A Type 3 Dimension Mapping
- Creating Targets In The Target Database
- Scheduling Sessions And Workflows
- Creating A Mapping From The Informatica Mapping Templates
Using The Designer
Working With Sources
Working With Flat Files
Working With Targets
Mappings
Mapplets
Mapping Parameters And Variables
Working With User-defined Functions
Using The Debugger
Viewing Data Lineage
Comparing Objects
Managing Business Components
Creating Cubes And Dimensions
Using The Mapping Wizards
