Informatica PowerCenter Developer Specialist flashcards
Informatica PowerCenter Developer Specialist · Build recall with a focused review session.
32 cards. Read the term and the definition here. The deck at the top of this page is optional.
- Global shortcut
- A repository object that references a definition held in a shared folder. It stays synchronized with the original and is the only way a non-shared folder can use that definition.
- Repository Service
- Service that stores and serves repository metadata held in OPB_ tables of the repository database. It handles client and Integration Service requests for objects but never moves data.
- Folder permissions
- Access rights of Read, Write, Execute and Administer granted to users and groups on a folder. Administer applies only to shared folders and governs folder properties and other users' permissions.
- Object versioning
- Repository feature where Save as Version stores a numbered snapshot of an object. Saved versions can be compared with the current object and restored, giving a rollback path for mappings and sessions.
- Source Qualifier
- Transformation added automatically with a relational or file source. Its ports define extracted columns, and it holds SQL override, user-defined join, source filter, distinct and sorted-ports properties.
- Target load plan
- Ordering of independent targets in a mapping. Targets joined by primary-key and foreign-key constraints ignore the plan and are always loaded in dependency order by the Integration Service.
- Treat source rows as
- Session property with values Insert, Update, Delete, Upsert or Data Driven. It must be set to Data Driven before Update Strategy codes coming from the mapping are applied to the target.
- Flat file definition
- Metadata describing a non-relational file: location, code page, delimited or fixed-width layout, delimiter, text qualifier, header and footer line counts, and the row holding column names.
- Filter transformation
- Transformation that passes a row only when its condition evaluates to TRUE. A condition returning FALSE or NULL causes the row to be dropped from the pipeline.
- Update Strategy codes
- Constants returned by an Update Strategy expression: DD_INSERT is 0, DD_UPDATE is 1, DD_DELETE is 2 and DD_REJECT is 3. The session applies them when source rows are treated as Data Driven.
- Sequence Generator NEXTVAL
- NEXTVAL returns the next value on each call, while CURRVAL returns the last value generated in that session. Cached values are allocated in blocks per session, so gaps appear after a restart.
- Union transformation
- Transformation that merges two or more input groups into a single output stream. It keeps duplicate rows, behaving as UNION ALL rather than as a duplicate-eliminating UNION.
- Dynamic lookup cache
- Lookup cache that is updated as rows pass through, adding a NewLookupRow port that returns 1 for insert, 2 for update and 0 when the row is unchanged.
- Unconnected lookup call
- Lookup invoked from an expression as :LKP.LOOKUP_NAME(arg1, arg2, ...). Each call returns one output port value based on the lookup condition, independent of the row pipeline.
- Rank transformation
- Transformation that returns the top or bottom N rows per group using Rank port, number of ranks and group-by ports. It requires sorted input and outputs a rank index.
- Stored Procedure execution option
- Property choosing when a stored procedure runs: Run on Every Row, Run Once, Run on First Row, Source Pre Load, Source Post Load, Target Pre Load or Target Post Load.
- Mapplet
- Reusable object containing transformations plus Mapplet Input and Output ports, inserted into mappings. It cannot contain target definitions or another mapplet, and needs an input port.
- Mapplet Input transformation
- Transformation inside a mapplet that receives ports linked from the mapping and passes those values into the mapplet pipeline. It defines the mapplet's external input interface.
- Transformation Developer
- Tool for creating and editing reusable transformations stored in the repository. Edits made there affect every mapping that instances the transformation, so those mappings need revalidation.
- Reusable transformation
- Transformation saved once in a folder and instanced by many mappings. It must be edited outside the mapping, and changing its ports or logic requires revalidating all dependent mappings.
- Worklet
- Reusable set of workflow tasks that contains no Start task. It is built in the Worklet Designer and inserted into workflows, where it runs as a nested group of tasks.
- Timer task
- Workflow task that delays the outgoing link either by a relative wait measured from workflow start or until a specified absolute time and date.
- Assignment task
- Workflow task that sets a workflow variable to the result of an expression, so subsequent link conditions and tasks can branch on the computed value.
- Decision task
- Workflow task that evaluates a condition built from workflow variables and then follows either the TRUE link or the FALSE link, branching the workflow path.
- Pushdown optimization
- Session option set to Source, Target or Full that converts compatible mapping logic into database SQL. It reduces data movement but only works for pushdown-compatible mappings.
- DTM buffer size
- Session memory setting, 12,000,000 bytes by default, that bounds total pipeline memory. Raising it reduces spilling to disk when sorters, aggregators or lookups hold many rows.
- Sorted input option
- Aggregator, Sorter and Joiner setting that skips the internal sort because incoming rows are already ordered on the keys, usually after setting Number of Sorted Ports.
- Session partitioning
- Splitting one pipeline into parallel partitions using database partitioning, hash auto-keys, hash user keys, key range, round-robin or pass-through, with a partition count and key per source qualifier.
- Session error limit
- Session property giving the maximum number of row errors allowed before the session fails. A value of 0 means the session stops at the very first error.
- Reject file
- File written in the session reject directory that holds rows rejected by the target or by the Update Strategy. The reason for each rejection appears in the session log.
- Session recovery strategy
- Session property set to Restart, Resume or Fail. Resume continues from the last commit point, Restart reprocesses from the beginning, and Fail disables recovery for that session.
- Commit interval
- Number of rows processed between commits, set on the session. It sets transaction size, affects throughput, and determines how much work is repeated when a recovered session resumes.