![]() ![]() (since we all refer to it that way anyway). I assume you are talking about PowerCenter.Īs Kareem indicated, Informatica 9 is basically starting to put many of their products under one banner, the "Informatica" banner. View the status of each monitored object on the Monitoring tab of Informatica Administrator. Monitoring: We can monitor profile jobs, scorecard jobs, preview jobs, mapping jobs, and SQL Data Services for each Data Integration Service. Create deployment units in Informatica Developer. Deploy Deployment units to one or more Data Integration Services. Create, view, edit, and grant permissions on database connections in Informatica Administrator.ĭeployment: We can deploy, enable, and configure deployment units in the Informatica Administrator. We can create and view database connections in Informatica Administrator, Informatica Developer, or Informatica Analyst. Integration Service: Create and enable a Model Repository Service on the Domain tab of Informatica Administrator.Ĭonnection management: Database connections are centralized in the domain. The Model repository also stores run-time and configuration information for applications deployed to a Data. The Model repository is a relational database that stores the metadata for projects created in Informatica Analyst and Informatica Designer. Model Repository Service: Application service that manages the Model repository. When the XML is not valid, the XML Parser transformation routes the XML and the error messages to a separate output group that We can connect to a target. The XML Parser transformation routes invalid XML to an error port. The XML Parser transformation can validate an XML document against a schema. XML transformation: XML Parser buffer validation. When the SQL transformation runs in passive mode, the SQL transformation returns one output row for each input row. Passive transformation: We can configure the SQL transformation to run in passive mode instead of active mode. We can also limit the number of log files for a session. We can limit the size by time or by file size. Session Log files rollover: We can limit the size of session logs for real-time sessions. A commit occurs when the SQL statement completes or the next statement is executed, whichever comes first. Each SQL statement in a query defines a transaction. We can enable auto-commit for each database connection. SQL transformation: Auto-commit for connections. We can configure the number of retry attempts and time period between attempts. When a deadlock occurs, the Integration Service attempts to run the last statement in a lookup. ![]() Effective in 9.0, the session will not fail. We can include lookup ports in the SQL query.ĭatabase deadlock resilience: In previous releases, when the Integration Service encountered a database deadlock during a lookup, the session failed. We can create an SQL override for uncached lookup. SQL overrides for uncached lookups: In previous versions We could create a SQL override for cached lookups only. A Lookup transformation is an active transformation when it can return more than one row for any given input row. Multiple rows return: We can configure the Lookup transformation to return all rows that match a lookup condition. We can update the dynamic lookup cache with the results of an expression. When an expression is true, We can add to or update the lookup cache. We can update the lookup cache based on the results of an expression. Architecture wise there are no differences between 8 and 9 but here are some new features added in powercenter 9 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |