Stack Overflow
Stack Overflow

Questions tagged [informatica]

Informatica is a software development company which provides multiple UI based tools for Data Integration, ensuring Data Quality and Master Data Management. Informatica PowerCenter, Informatica PowerExchange, Informatica MDM, B2B Data Exchange are few of them.

Informatica PowerCenter is a UI-based ETL tool used in a data warehouse setup. It has the capability to load to/from a wide variety of file formats. UI makes it easy to describe transformation rules.

Informatica PowerCenter promotes re-usability. You could have reusable sessions, mapplets, and worklets.

The application provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store (ODS).

Informatica PowerCenter includes the following components:

  • Informatica domain - the primary unit for management and administration within PowerCenter.

  • PowerCenter repository - it resides in a relational database. The repository database tables contain the instructions required to extract, transform, and load data.

  • Informatica Administrator - a web application that you use to administer the Informatica domain and PowerCenter security.

  • Domain configuration - a set of relational database tables that stores the configuration information for the domain.

  • PowerCenter Repository Service

  • PowerCenter Integration Service - extracts data from sources and loads data to targets

  • Web Services Hub - a gateway that exposes PowerCenter functionality to external clients through web services

  • SAP BW Service - extracts data from and loads data to SAP NetWeaver BI.

  • Reporting Service - runs the Data Analyzer web application

  • Metadata Manager Service - runs the Metadata Manager web application.

  • PowerCenter Client - consists of the tools to manage the repository and to design mappings, mapplets, and sessions to load the data. It has the following tools:

  1. Designer - Define source, targets, transformations, and mapping here.
  2. Repository Manager - to assign permissions to users and groups and manage folders.
  3. Workflow Manager - to create, schedule, and run workflows. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data.
  4. Workflow Monitor - to monitor scheduled and running workflows for each Integration Service.

PowerCenter accesses the following sources:

  • Relational DB

  • File - Fixed and delimited flat file, COBOL file, XML file, and weblog

  • Other - Microsoft Excel, Microsoft Access, and external web services, mainframe and applications

PowerCenter can load data into the following targets:

  • Relational DB

  • File - Fixed and delimited flat file and XML.

  • Other - Microsoft Access and external web services, applications, and mainframe.

You can load data into targets using ODBC or native drivers, FTP, or external loaders.

Other information:

Getting started

User guide

Related Tags :

Reference :

Tutorials:
User guide
Documentation

1803 questions
12
votes
2 answers

Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality,…
Ashish Sachdeva
  • 153
  • 1
  • 2
  • 11
11
votes
1 answer

Can ETL informatica Big Data edition (not the cloud version) connect to Cloudera Impala?

We are trying do a proof of concept on Informatica Big Data edition (not the cloud version) and I have seen that we might be able to use HDFS, Hive as source and target. But my question is does Informatica connect to Cloudera Impala? If so, do we…
sun_dare
  • 1,146
  • 2
  • 13
  • 33
11
votes
1 answer

How to Create a Process in Informatica Cloud Real time which gets exposed as Restful service and can be invoked from browser or else where?

Can we create a Webservice using Informatica? I am very new to Informatica. Is the below requirement possible in using Informatica? My requirement is - "I want to create a Real Time RESTful webservice within Informatica Cloud which will fetch data…
Oliver
  • 6,152
  • 2
  • 42
  • 75
10
votes
3 answers

Kafka vs StreamSets

I was reading articles related to Kafka and StreamSets and my understanding was Kafka acts as a broker between Producer system and subscriber. Producer push the data into Kafka cluster, subscriber pull the data from Kafka StreamsSets is a…
NikRED
  • 1,175
  • 2
  • 21
  • 39
8
votes
6 answers

The Repository Service marked the session or session instance as impacted

I am new in control-M. I have a work flow that i developed in Informatica....When i run the work flow in informatica workflow manager itz working fine...but when i scheduled it in Control-M Its making an error - The Repository Service marked the…
Sinoy Devassy
  • 564
  • 4
  • 11
  • 27
6
votes
1 answer

Auto mapping target fields from source in informatica

I hav a source structure in informatica like col1 number col2 varchar(40) col3 DATE col4 varchar(50) col5 number and my target definition is like col4 varchar(50) col1 number col5 number col3 varchar(40) col3 DATE If i want to load…
Aspirant
  • 2,238
  • 9
  • 31
  • 43
5
votes
3 answers

Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'sa'

Im installing the MDM of Informatica. MDM 10.2 - Jboss 6.4 EAP - SQL Server 11 - Windows Server 2008 R2. During the creation of the schema 'sip_ant.bat create_bpm' i got this error Microsoft ODBC Driver 13 for SQL Server : Login failed for user…
DanieleO
  • 462
  • 1
  • 7
  • 20
5
votes
3 answers

why do people choose SnapLogic over informatica for cloud integration?

We are looking for a good cloud integration tool. we have informatica cloud and SnapLogic as an option, but still looking for more information what key features differentiate these two tools? people are choosing SnapLogic over informatica these…
Dirjit
  • 87
  • 1
  • 8
5
votes
3 answers

Is it possible to get the SQL that would be generated, without running the mapping?

We can see the SQL's generated by PowerCenter in the session log file once a mapping has been run. So to get these SQLs we have to run the mapping. I would like to know if there is any way to get the SQL that PowerCenter would generate without…
user1021822
  • 59
  • 1
  • 4
  • 9
4
votes
1 answer

Pass a specific time with today's date as a value to the input field in Informatica Cloud

There is a mapping task which has a input field, the value provided to the field should be today's date and time is 18:00:00.000000000. What is the formula to build this one? Suppose the current month is 9, it should be passed as 09. Same with the…
Teja Goud Kandula
  • 1,462
  • 13
  • 26
4
votes
0 answers

Error:java.lang.RuntimeException: Error in configuring object

I am running a mapping using informatica Developer tool. When i run my mapping in dev environment it works fine, where as when i try to read from prod and write to Dev it fails. Difference between Dev & Prod Source Hive Table. Dev table DDL…
Imran Syed
  • 41
  • 4
4
votes
1 answer

"Metadata driven" means what? I keep hearing this phrase in ETL context but could never figure it out

Appologies if I am asking a inappropraite question but I have been hearing this phrase "Metadata driven" for years but could not ever understand. Metadata as per my understanding is Data (iformation) about data! I understand this more or less!! But…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
3
votes
2 answers

Informatica error =[ERROR('transformation error')]

I am getting the following Informatica error: Note: Output column [AGENT_DISPOSTION_CODE] has no default value. Row will be skipped if transformation errors are encountered MAPPING> DBG_21056 column=[PHONE_NUMBER],…
user1173496
  • 111
  • 4
  • 8
  • 18
3
votes
1 answer

How to update variable inside a parameter file

lets say i have a parameter file [Global] $$param1=x $$param2=r $$param3=t $$param4=h $$param5=j $$Counter=0 what i want is whenever i run the session the parameter file updates and $Counter variable increments by 1 so that it be like this after…
Mark
  • 53
  • 4
3
votes
1 answer

How to create series of date range in INFORMATICA using transformations?

I have a need to create a report , where some dates are present in the table,however the requirement is the report should consist of every monday for the entire year irrespective of the data unavailability(it`ll show null for those dates) . How to…
Pratyush Rout
  • 31
  • 2
1
2 3
…
99 100