Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
170 Cards in this Set
- Front
- Back
Name the 5 top level tabs in Administrator
|
- Domain
- Logs - Monitorinig - Reports - Security |
|
Name the 2 tabs below Domain in Administrator
|
- Services and Nodes
- Connections |
|
Name the 5 tabs below Services and Nodes in Administrator
|
- Overview
- Properties - Resources - Permissions - Diagnostics |
|
Describe the difference between Gantt Chart and Task View in Monitor
|
Gantt Chart allows you to find what happened at a specific time
Task View allows you to drill down to a specific wf/session and see its details |
|
What is shown in the Output Window in Monitor?
|
Messages from the Integration Service
|
|
Name 5 PowerCenter client tools
|
- Repository Manager
- Workflow Manager - Designer - Workflow Monitor - Administrator |
|
Name the left pane in Administrator
|
Navigator
|
|
Name the right pane in Administrator
|
Content panel
|
|
What's the purpose of the Monitoring tab?
|
to monitor objects run on the Data Integration Service
|
|
What's the URL of Administrator?
|
http://host:port/administrator
|
|
Name all tasks usable in workflow manager (11)
|
Start, Command, Email. worklet, event wait, event raise, control, decision, assignment, time, Session
|
|
What are the sections of a sessions properties (2)
|
General and Performance
|
|
What are the sections on the config object (5)
|
Advanced, Log options, Error handling, Partitioning Options, Session on Grid
|
|
What does a control task do?
|
Stop, abort or fail the parent workflow on an input link condition
|
|
Two types of events
|
User defined and predefined (filewatch)
|
|
Describe the use of link conditions
|
The integration service runs a tasks if the incoming link conditions evaluate to true (either all in AND modus, or at least one in OR modus)
|
|
What can you do with the decision task?
|
Implement if-then-else logic, mostly based on run status of previous tasks
|
|
How is the repository database accessed?
|
The clients connect through the repository service
|
|
What is a repository domain?
|
A group of repositories sharing data through a global repository
|
|
How does a client connect to the repservice? (4 steps)
|
1. client sends request to master gateway
2. service manager send hostname and port of node running RS 3. client establishes link with RS 4. RS performs repository metadata transactions for the client |
|
What are the objects create in Designer? (8 kinds)
|
1. Sources
2. Targets 3. Transformations 4. Reusable transformation 5. Mappings 6. Mapplets 7. UDFs 8. Multidimensional metadata (dimensions and cubes) |
|
What are the objects create in WF Manager? (5)
|
1. Database connections
2. Sessions 3. Workflows 4. Workflow tasks 5. Worklets |
|
What are global objects?
|
Objects not bound to a particular folder
|
|
What are the different global objects
|
- Labels
- Deployment groups - Object queries - Connection object |
|
What are dependent objects? Give an example.
|
Objects used by another object. A source is a dependent object of a mapping
|
|
What are the 3 types of locks?
|
- In-use lock. Objects you want to view
- Write-intent. Objects you want to modify - Execute lock. Objects you want to run |
|
Can multiple users hold a write-intent lock?
|
No. This is to avoid inconsistencies.
|
|
Can multiple users hold an execute intent lock?
|
No. This is to avoid loading duplicate or incoherent data.
|
|
What the symbol of an impacted object?
|
A yellow warning sign.
|
|
Where are users,groups,privileges and roles stored?
|
In the domain db and periodically synced to the repository by the Service Manager
|
|
How are session and workflow logs stored?
|
In files. In the repository there's a pointer to these files.
|
|
What permissions can a user have on objects?
|
rwx
|
|
If an object changes, what happens to the shortcut pointing to it?
|
It sees all those changes. A shortcut is like a symlink in Unix.
|
|
What's the difference between a local and a global shortcut?
|
A global shortcut points to a different (global) repository, a local one to the same repository
|
|
Can you create a shortcut to a global repository folder that is not shared?
|
No, but you can copy it.
|
|
Difference static and dynamic deployment group?
|
You manually add objects to static. For dynamic, a query is run the moment you deploy.
|
|
How can you copy from one repository to the other?
|
- Copy a folder
- Replace a folder - Copy a deployment group |
|
Give an example of a possible usage for a metadata extension
|
A contact for each object
|
|
What's in the last 50 pages or so of the Repository Guide?
|
Detailed descriptions of the MX views.
|
|
Which products are part of the Informatica platform?
|
Data Quality
Data Explorer Data Services PowerCenter |
|
What are the application services for PowerCenter? (6)
|
PowerCenter Repository Service
PowerCenter Interation Service Metadata Manager Service Reporting Service Web Services Hub SAP BW Service |
|
How much temp space is required during installation? How can you set it to a particular directory?
|
1GB. By setting the environment variable IATEMPDIR
|
|
LIst the ports used by an Informatica domain (6 items)
|
- Node port
- Service Manager port - Service Manager shutdown port - Administrator port - Administrator shutdown port - Application services ports (from port range |
|
How are keys for SSL managed?
|
Using the keytool utility from java/bin or jre/bin
|
|
Can the communication between domain nodes/services be encrypted?
|
Yes, by using TLS
|
|
Is there a silent install option for the server?
|
Yes. Configure SilentInput.properties.
|
|
Is there a silent installer option for the clients?
|
Yes. Configure SilentInput.properties.
|
|
Where is connectivity information for gateway nodes stored?
|
In domains.infa. There's an environment variable that specifies where to find this file.
|
|
How can you get more informations about a failing installation?
|
Installation or upgrade logs from the installation directory.
|
|
What is a privilege?
|
A privilege determines whether a particular action can or cannot be performed
|
|
What is a role?
|
A collection of privileges.
|
|
What is a privilege group?
|
A way to organize privileges. Examples: domain privileges, DIS privilege...
|
|
Where can you look up privilege definitions?
|
Informatica Administrator Guide
|
|
What are the 2 types of roles?
|
System defined and custom
|
|
Where does a shortcut point to in a versioned repository?
|
Always to the latest version of the referenced object
|
|
Where must the referenced object of a shortcut be?
|
In a shared folder
|
|
2 types of shortcuts:
|
* Global - in a global repository
* Local - in a shared folder in the same repository |
|
If you change a shortcut, you may invalidate potentially many mappings using it. How can you find out which?
|
Using the Analyze Dependencies feature in Repository Manager
|
|
What's the alternative to shortcuts?
|
Copying objects.
|
|
3 types of copy operations
|
- Copy folder
- Replace folder - Copy deployment group |
|
What happens if you copy a folder and a folder with the same name already exists in the target repository?
|
The new folder will get a different name including a timestamp
|
|
What happens to shortcuts when copying? What if the object pointed to is not available in the target repository?
|
The copy wizards can perform some logic to try to re-establish shortcuts. If not possible, the mapping will become invalid.
|
|
Where do you define Metadata Extensions?
|
Repository Manager -> Edit -> Metadata
|
|
2 types of Metadata Extension
|
reusable and non-reusable
|
|
What's the code page of the domain database?
|
UTF-8
|
|
What's the relationship between source and target code page?
|
Target codepage must be a superset of source codepage. Otherwise inconsistencies will occurr.
|
|
How do database server and client codepage interact?
|
The database client layer converts to the client codepage. PowerCenter interacts with the DB client codepage.
|
|
Does the Integration Service validate code pages?
|
Only when running in Unicode more
|
|
What code page do you choose for a relational connection?
|
The code page of the database client
|
|
How do you set the Oracle client code page?
|
By setting the environment variable NLS_LANG
|
|
Which code page does PowerCenter use internally when running in Unicode mode?
|
UCS-2
|
|
What privileges are needed in order to develop workflows?
|
Access Workflow Manager
|
|
How can you delete an Integration Service from Workflow Manager?
|
Right click IS in navigator pane
->Delete |
|
How can you configure how times and dates are displayed in Workflow Manager?
|
In the WIndows Control Panel, Regional Settings
|
|
Where can you set Workflow Manager options?
|
Edit->Options.
|
|
What are the default permissions on a connection for all users if you disable enhanced security?
|
rwx
|
|
How do link conditions work?
|
If the link condition evaluates to true, the next task is executed
|
|
What happens if no link condition is specified for a link?
|
The Integration Service simply executes the next task
|
|
Can you run multiple instances of the same workflow in parallel?
|
Yes. You have to configure the workflow for concurrent execution in the workflow settings, tab General.
|
|
What happens if you select Save Workflow Logs by Timestamp?
|
_All_ workflow logs will be saved, with a timestamp appended to the file name.
|
|
Which are the tabs in the Workflow properties dialog?
|
General, Properties, Scheduler, Variables, Events
|
|
Is it possible to configure instances of one workflow to run at different times?
|
No.
|
|
How can you permanently unschedule a workflow?
|
Configure it to run on demand.
|
|
Are scheduler objects global?
|
No, schedulers are per folder.
|
|
What's a reusable scheduler?
|
A scheduler stored in a folder that can be referenced by several workflows.
|
|
What happens if you set a scheduler to "run continuosly"?
|
It runs as soon as the IS initializes, and then as soon as the previous run is terminated.
|
|
How can you select a different OS profile when starting a workflow?
|
Right click -> Start Workflow -> Advanced
|
|
Can you run only part of a workflow?
|
Yes - you can select "start workflow from task"
|
|
How can you run a specific task from the command line?
|
pmcmd starttask
|
|
Where does the Log Manager store information about workflow and session logs?
|
In the domain configuration database
|
|
What happens when you tell Workflow Manager to display a session or workflow log?
|
1. WF Manager asks Log Manager to retrieve the log.
2. Log Manager looks up the location in the domain configuration DB. 3. Log Manager dispatches a Log Agent on each node to retrieve the log |
|
What's the default code page of session/workflow logs?
|
The code page of the Integration Service
|
|
What's the default log format for sessions/workflows? How can you change it?
|
Default is binary. It can be change to txt by selecting "Write backward compatible log file"
|
|
Can you configure the maximum session log size?
|
Yes. In the COnfig Object, tab "Advanced", Session Log File Max Size
|
|
What happens if you stop or abort a specific task in a workflow?
|
The Integration Service does not execute the other tasks in its path. The other branches of the workflow are still executed.
|
|
What happens if you stop a Command Task?
|
The current command is still executed, but the following one(s) are not.
|
|
Two types of session errors
|
Threshold (reader, writer, transformation errors)
Fatal (IS cannot access source, target or repository) |
|
What happens when you abort a session?
|
It stops reading, but continues processing/writing/committing for 60 seconds. Then it kills the pmdtm.
|
|
What happens when you stop a session?
|
It stops reading, but continues processing/writing/committing.
|
|
What's the difference between native and transformation datatypes?
|
Native is the database datatype. Transformation datatypes are based on SQL92 and are used internally by PowerCenter
|
|
What's the "binary" dataype?
|
Basically a blob. You can pass it through a mapping but not perform any logic on it.
|
|
Precision and scale for the 3 integer datatypes
|
Bigint: 19,0
Integer: 10,0 Small Integer: 5,0 |
|
Maximum precision of the decimal datatype
|
28. You can assign higher values in Designer, but the IS does not support them
|
|
Where can you look up details on which native types are converted to which transformation types?
|
Designer Guide, Appendix A
|
|
Does updating a source definition affect the mappings using it?
|
It depends. Some things (like adding another column) can be changed without invalidating the mapping.
|
|
How can you update a source definition?
|
Reimport or edit manually.
|
|
Can you use 3rd party ODBC drivers to import metadata?
|
Yes, but Designer will complain that the drivers is not listed in powrmart.ini
|
|
Where is powrmart.ini located?
|
In client\bin
|
|
How can you change a flat file definition?
|
Tab "Table", Advanced
|
|
How can you add comments in an expression?
|
By either prefixing them with // or --
|
|
How are strings specified in an expression?
|
Contained in single quotes
|
|
Which character cannot appear in a string in an expression?
|
The single quote. Use ||chr(39)|| if you need it.
|
|
Is the transformation language case sensitive?
|
No, except for string literals ('like tHiS')
|
|
How many functions are there in the expression language?
|
Over 100
|
|
4 condition that must be satisfied for port connections to be valid
|
1. At least 1 source and target must be connected
2. SQs must be mapped to a target 3. Mapplets must be connected 4. Port datatypes must be compatible |
|
What is object validation?
|
Designer verifies that the definitions of the independent objects, such as sources or mapplets, match the instance in the mapping. If any object changes while you configure the mapping, the mapping might contain errors.
|
|
What is data flow validation?
|
Designer verifies that the data can flow from all sources in a target load
order group to the targets without the Integration Service blocking all sources. |
|
What's the purpose of built-in variables?
|
To provide access to runtime and system information
|
|
Can you nest aggregate functions?
|
Only one level deep, i.e one within another, like sum(avg(...))
|
|
What are encoding functions?
|
Functions that compress, calculate hashes, and similar
|
|
What's the purpose of the special functions?
|
These are functions that make sense only in a PowerCenter context, like ABORT to abort a session
|
|
What's the purpose of variable functions?
|
To manipulate mapping variables.
|
|
What does the Source Qualifier represent?
|
The rows that are read from the source.
|
|
What can you do with the SQ?
|
Join tables in same DB, sort, filter, select distinct
|
|
Which ports are selected in the default query for a relational source?
|
Only the ports connected downstream of the SQ
|
|
WHat's the condition for joining in the SQ?
|
The connected tables must reside in the same database.
|
|
How can you specify primary key relationships in Designer?
|
By linking ports in Source Analyzer
|
|
How can you view the default SQL query generated for an SQ?
|
Properties -> SQL Query ->Generate (and then cancel)
|
|
What's Informatica join syntax?
|
A proprietary way to specify join conditions that gets translated to database join syntax. Docs say to not use it.
|
|
Can aggregate functions be used in an Expression Transformation?
|
No. Only in Aggregator.
|
|
When does it not help to select "sorted input" in an Aggregator?
|
* When using incremental aggregation
* When using nested aggregate functions * When the source is data driven |
|
What is incremental aggregation?
|
Index and data caches are reused in the next run, incrementing as new data comes in
|
|
What's the use of variable ports in an Aggregator?
|
Store reusable components of expressions. This improves performance (according to the docs)
|
|
What's the use of group by ports in an Aggregator?
|
The IS produces one row for each group. If you select multiple group by ports, the IS produces one row for each unique combination.
|
|
What's the relationship between CURRVAL and NEXTVAL in a Sequence Generator?
|
CURRVAL = NEXTVAL + Increment-By value
|
|
Which of these operations can you perform on Sequence Generator ports: add, update, delete
|
None of them.
|
|
If you connect a Sequence Generator port to 2 different targets, what will be the result?
|
They will contain different values. If you need the same value in both, pass them to a different transformation first.
|
|
What happens if you specify more than one sort key in a Sorter?
|
They will define primary, secondary, ... sort orders, based on the order of the ports in the Sorter.
|
|
What's the Sorter work directory? (3 points)
|
* It's where the Sorter stores temporary files.
* Defined by $PMTempDir by default. * Can be split to different places, one for each partition (possibly improve disk performance) |
|
How can you configure a Sorter to discard duplicate rows?
|
Select Distinct Output Rows.
|
|
What's a typical use of Lookups in a dimensional warehouse?
|
Update slowly changing dimensions: check if a row exists in the target
|
|
What's a pipeline lookup?
|
A lookup on an application source (JMS, SAP). Connect SQ to pipeline lookup
|
|
What's the purpose of dynamic lookup cache?
|
It can be updated. There are configuration options for the different update strategies.
|
|
What's a shared lookup cache?
|
A cache that is shared between different transformations. If it is named, it can also be shared between different mappings. Its purpose is to increase performance.
|
|
What's a persistent lookup cache?
|
Saves the cache files between runs. You can select to recache in the session properties when the source changes.
|
|
How does the IS work with master and detail branch of a Joiner?
|
Each row from the master is compared against the detail
|
|
Which one of two branches should be master for a Joiner?
|
The one with less rows.
|
|
What does a master outer join do?
|
Keep all rows from the detail and the matching ones from the master
|
|
What's the best way to increase Joiner performance?
|
Use sorted data.
Join in the database. |
|
How can you join a source to iself? (2 methods)
|
* Use 2 instances of the source.
* Put a transformation in one branche between SQ and joiner |
|
How can you configure whether to update or insert rows in a target?
|
Either at the session level, or within a mapping with an Update Strategy
|
|
What are the 4 constants used in the update strategy expression?
|
dd_update, dd_insert, dd_delete, dd_reject
|
|
When you using an Update Strategy, the field Treat Source Rows As in the session properties should be:
|
Data Driven
|
|
What happens if you put an aggregator behind an update strategy?
|
It will perform different calculations based on how the row is flagged
|
|
How are rejected rows handled by the update strategy?
|
By default they are passed to the next transformation and written to the row error log if row error handling is enable. You can configure the Update Strategy to drop them
|
|
What's a filter condition?
|
A condition that returns a boolean value, used in a Filter
|
|
What's the function of the default group in a Router?
|
Rows that don't go into any other group go into the default group.
|
|
Can you change the output ports of a Router?
|
No. Datatypes are copied from the input group.
|
|
Can a Mapplet have multiple pipelines?
|
Yes
|
|
Can a Mapplet have multiple Output transformations?
|
Yes. They will appear as separate groups when you use the mapplet in a mapping.
|
|
How can you view the contents of a mapplet?
|
Mappings -> Expand from the menu
|
|
Can mapplets be nested?
|
No
|
|
Name a transformation that cannot be used in a mapplet
|
Normalizer
|
|
What kind of sources can be previewed in Designer?
|
Relational, flat files, XML
|
|
How do you preview XML data?
|
In the XML editor, select a view, then XML Views -> Preview and select a file
|
|
3 ways to define an XML target
|
* From an XML schema or file
* From an XML source * From a relational or flat file source |
|
Difference between creating hierarchy or creating entity relationships in the XML import wizard
|
Hierarchy creates one big hierarchy (normalized or denormalized), while entity creates views for multiple-occurring elements.
|
|
Does PowerCenter support all XML datatypes?
|
No. There are 13 unsupported datatypes in 9.1. Always check.
|
|
Can you generate an XML target from relational tables?
|
Yes. If they are related through primary key relationships, the XML will be structured accordingly
|
|
What happens if generate hierarchies in the XML import wizard?
|
Each reference to a component is expanded under its parent element.
|