29. What are features of Informatica Repository Server?
Features of Informatica Repository Server.
1. Informatica client application and Informatica server access the repository database tables through the Repository Server.
2. Informatica client connects to the repository server through the host name/ IP address and its port number.
3. The Repository Server can manager multiple repository on different machines on the network.
4. For each repository database registered with the Repository Server it configures and manages a Repository Agent process.
5. The Repository Agent is a multi-threaded process that performs the action needed to retrieve, insert and updated metadata in the repository database tables.
30. How many types of Repositories are there?
There are three types of Repositories:
1. Standalone Repository
2. Global Repository
3. Local Repository
31. What are the types of metadata stored in Repository?
The following types of metadata are stored in Repository:
1. Database connections
2. Global objects
3. Mappings
4. Mapplets
5. Multi-dimensional metadata
6. Reusable Transformations
7. Sessions and Batches
8. Shortcuts
9. Source Definitions
10. Target definitions
11. Transformations
32. What are the types of locks in Repository?
There are two types of Locks in Repository:
1. Read Lock
2. Write Lock
3. Execute Lock
4. Fetch Lock
5. Save Lock
33. What are Repository objects which we can export?
We can export the following Repository objects:
1. Sources
2. Targets
3. Transformations
4. Mapplets
5. Mappings
6. Sessions
34. What is a Work Flow?
A Work Flow is a set of instructions on how to execute tasks such as sessions, emails and shell commands. A WorkFlow is created from Workflow Manager.
35. What are actions which can be performed by pmcmd command?
We can perform the following actions with pmcmd:
1. Check whether the Informatica server is running
2. Start and stop sessions and batches
3. Recover sessions.
4. Stop the Informatica server.
pmcmd returns zero on success and non zero on failure
36. What is commit interval?
A commit interval is the interval at which the Informatica Server commits data to relational targets during a session.
37. What is the use of Stored Procedure Transformation?
We use the Stored Procedure Transformation for populating and maintaining the database.
38. What is the use of partitioning the sessions?
The partitioning of session increases the session performance by reducing the time period of reading the source data and loading the data into the target.
39. What is the uses of Lookup Transformation?
The Lookup Transformation is useful for:
1. Getting a related value form a table using a key column value
2. Update slowly changing dimension table
3. To check whether records already exists in the table.
40. What is Polling?
It displays the update information about the session in the monitor window. The monitor window displays the status of each session when you poll the Informatica Server.
41. What is a Parameter File?
The parameter File is used to define the values of the parameters and variables used in a session. It is a file created in a notepad and saved with .prm extension.
42. What is Metadata Reporter?
It is a web based application that enables you to run reports against the repository metadata. With a metadata reporter you can access information about your repository without having knowledge of SQL.
43. What is meant by Lookup Cache?
The Informatica server builts a cache in memory when it process the first row of a data in a cached lookup transformation.
source:www.dwhetltool.co.cc
0 comments:
Post a Comment