Karteikarten
Ohne Titel
Karten in diesem Stapel (12)
- 1Types of Repositories1. Standalone
2. Global - centralized in a Domain, shared objects through global shortcuts
3. Local - within a domain, can connect to a global repository using global shortcuts, can use objects in shared folders
4. Versioned - either local or global, allows version control for the repository - 2Workflow Manager ToolsTask Developer
Workflow Designer
Worklet Designer - 3Workflow TasksAssignment - assign value
Command - shell command to run during workflow
Control - stop or abort workflow
Decision - specifies condition to evaluate
Email - sends email during workflow
Even Raise - notifies Event wait that even occurred
Event Wait - waits for event to occur before executing next task
Session - runs a mapping created in the Designer
Timer - waits for a timed event - 4Active TransformationChanges the number of rows that pass through the transformation - ex. Filter trans
Change the transaction boundary - ex. Transaction Control
Change the row type - ex. Update Strategy flags rows for insert, delete, update, and reject
All multi-group transformations are active - 5Passive TransformationDoes not change the number of rows that pass through the transformation
- 6Connected and Unconnected TransformationThe transformation can be connected to the data flow, or not connected.
- 7Multi-group TransformationsAre all active transformations.
Blocking transformations - Custom transformation with the Inputs May block property enabled
Joiner transformation - configured for unsorted input - 8Expressions in TransformationsAggregator, Data Masking, Expression, Filter, Rank, Router, Update Strategy, Transaction Control
- 9Local Variables in TransformationsAggregator, Expression, Rank - to improve performance
- 10Variable Ports Configuration in TransformationsPort Order - input, variable port, output
Datatype - reflects the return value of the expression
Variable Initialization - IS sets initial value in variable port where you can create counters.
Zero - numeric ports
Empty String - string ports
Do not support default values. IS initializes them based on datatype.
01/01/0001 - date/Time ports - 11Default Values for Ports in TransformationsInput, Pass Through - NULL, IS passes input values as NULL
Output, Pass Through - ERROR, IS calls ERROR function , skips rows with errors, writes input data and error to log file - 12User Defined Default Values in TransformationsCan override system default values with user-defined values in connected transformation
Informationen
- Beschreibung
- Karteikarten am Ohne Titel, erstellt von v_krejci am 05/11/2015.
- Erstellt von
- v_krejci
- Aufrufe
- 0
- Bewertung