Category: Informatica

Overview of Deployment groups in Informatica

Informatica groups

Deployment groups in Informatica are used as containers that allow smart grouping of objects to facilitate the deployment between different folders, repositories, and environments. Deployment Groups consists of two different types such as Static and Dynamic. Informatica Deployment Groups can contain folders, mappings, mapplets, reusable transformations, sources, targets, workflows, sessions, and tasks and can help transfer these objects into multiple folders across repositories in different domains. Static group is generally used for one-off objects transfers and also you can annually add a specific version of your objects. Dynamic group is generally used for recurring objects transfers. This dynamic group is also a Query-driven object list capturing the latest version of frequently updated objects DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Tracing levels types in Informatica

Informatica ETL

Informatica tracing levels can be configured at the transformation session levels and has 4 different types of tracing levels. None – This level is applicable at session level only and the integration service uses the tracing levels configured in the mapping Terse – Log initialization information, error messages and notification of rejected data in the session log file. Normal – Integration service logs initialization and status information, errors encountered and skipped rows due to transformation row errors. Summarizes session results but not at the level of individual rows. Verbose Initialization – In addition to normal tracing the integration service logs additional initialization details; names of index and data files used and detailed transformation statistics. Verbose Data – The Informatica Integration Service logs each row that passes into mapping. When you configure the tracing level to verbose data, the Integration Service writes row data for all rows in a block when it processes a transformation. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

What is Stored Procedure Transformation in Informatica

Informatica BI

Stored Procedure Transformation in Informatica is a passive transformation and can be used in both connected and unconnected mode. The stored procedures are stored and run within the database and it also contains a pre-compiled collection of PL-SQL statements. Some of the tasks you can do with stored procedures areCheck the status of a target database before loading data into it.Determine if enough space exists in a database.Perform a specialized calculation.Dropping and recreating indexes. Informatica stored procedures must exist in the database before creating a stored procedure transformation and the stored procedure can exist in a source, target or any database with valid connection to the integration service. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Where to use Informatica and DataStage

Datastage and Informatica

DataStage is an ETL tool that extracts data, transforms and loads data from source to the target. DataStage facilitates business analysis by providing quality data to help in gaining business intelligence. Informatica is used for Data integration. Informatica offers the capability to connect & fetch data from different heterogeneous sources and processing of data. These are the major differences between Informatica and DataStage, you can select the relevant tool based on the requirement: ● Multiple Partitions: Informatica offers partitioning as dynamic partitioning which defaults a workflow, not at every Stage. It also offers other partitioning choices as well at the workflow level. Whereas, DataStage offers 7 different types of multi-processing partitions. ● User Interface: Informatica offers access to the development and monitoring effort through its 4 GUIs – offered as Informatica PowerDesigner, Repository Manager, WorkflowDesigner, Workflow Manager. Whereas, DataStage caters to development and monitoring its jobs through 3 GUIs – IBM DataStage Designer(for development), Job Sequence Designer(workflow design) and Director(for monitoring). ● Type of Link: To link two components in Informatica, link at the column level and connect each and every column between the two components. While, In DataStage, link at the component level, and then map individual columns. This […]

Read More +