23. What is a Repository?
Repository is a centrally stored container which stores the metadata, which is used by the Informatica Power center server and Power Center
Informatica 7.1.1 Repository has 247 database objects
Informatica 6.1.1 Repository has 172 database objects
Informatica 5.1.1 Repository has 145 database objects
Informatica 4.1.1 Repository has 111 database objects
24. What is Data Acquisition Process?
The process of extracting the data from different source (operational databases) systems, integrating the data and transforming the data into a homogenous format and loading into the target warehouse database. Simple called as ETL (Extraction, Transformation and Loading). The Data Acquisition process designs are called in different manners by different ETL vendors.
Informatica ----> Mapping
Data Stage ----> Job
Abinitio ----> Graph
25. What are the GUI based ETL tools?
The following are the GUI based ETL tools:
1. Informatica
2. DataStage
3. Data Junction
4. Oracle Warehouse Builder
5. Abinitio
6. Business Object Data Integrator
7. Cognos Decision Stream.
26. What are programmatic based ETL tools?
1. Pl/Sql
2. SAS BASE
3. SAS ACCESS
4. Tera Data Utilities
a. BTEQ
b. Fast Load
c. Multi Load
d. Fast Export
e. T (Trickle) Pump
27. What is a Transformation?
A transformation is a repository object that generates, modifies, or passes data. Transformations in a mapping represent the operations the PowerCenter Server performs on the data. Data passes into and out of transformations through ports that you link in a mapping or mapplet. Transformations can be active or passive. An active transformation can change the number of rows that pass through it. A passive transformation does not change the number of rows that pass through it.
28. The following are details description of Transformations available in Informatica.
Transformation | Type | Description |
Aggregator | Active / Connected | Performs aggregate calculations |
Application Source Qualifier | Active / Connected | Represents the rows that the Power Center Server reads from an application, such as an ERP source, when it runs a session. |
Custom | Active or Passive / Connected | Calls a procedure in a shared library or DLL. |
Expression | Passive / Connected | Calculates a value |
External Procedure | Active / Connected or Unconnected | Calls a procedure in a shared library or in the COM layer of windows. |
Filter | Active / Connected | Filters data |
Input | Passive / Connected | Defines mapplet input rows. Available in the Mapplet Designer |
Joiner | Active / Connected | Joins data from different databases of flat file systems. |
Lookup | Passive / Connected or Unconnected | Looks up values |
Normalizer | Active / Connected | Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources. |
Output | Passive / Connected | Defines mapplet output rows. Available in the Mapplet Designer. |
Rank | Active / Connected | Limits records to a top or bottom range. |
Router | Active / Connected | Router data into multiple transformations based on group conditions. |
Sequence Generator | Passive / Connected | Generates primary keys. |
Sorter | Active / Connected | Sorts data base4d on a sort key. |
Source Qualifier | Active / Connected | Represents the rows that the PowerCenter Server reads from a relational or flat file source when it runs a session. |
Stored Procedure | Passive / Connected or Unconnected | Calls a stored procedure. |
Transaction Control | Active / Connected | Defines commit and rollback transactions. |
Active / Connected | Merges data from different databases or flat file systems. | |
Update Strategy | Active / Connected | Determines whether to insert, delete, update, or reject rows. |
XML Generator | Active / Connected | Reads data from one or more input ports and outputs XML through a single output port. |
XML Parser | Active / Connected | Reads XML from one input port and outputs data to one or more output ports. |
XML Source Qualifier | Active / Connected | Represents the rows that the PowerCenter Server reads from an XML source when it runs a session. |
0 comments:
Post a Comment