Category: DataStage

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 +

Overview of External Loading in Informatica

Informatica

Sessions in Informatica can be configured to use IBM DB2, Oracle, Sybase IQ and Teradata external loaders to load target files into their respective database. Certain rules need to be followed before you begin to run external loaders. Disable Constraints – You disable constraints built into the tables receiving the data before performing the load. Turn off or disable database logging – By increasing the commit intervals and turning off the database logging you can preserve high performance in the database; but to perform database recovery on failed sessions, you must have database logging turned on. Configuring the code pages – All the external database servers must use the same code page as the target flat file code page. The integration services in Informatica create the control files and target flat files using the target flat file code page. Configuring the external loader connection as a resource – If the integration service is configured to run on a grid then configure the external loader connection as a resource on the node where the external loader is available. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and […]

Read More +