Top "Informatica" questions

Informatica is a software development company which provides multiple UI based tools for Data Integration, ensuring Data Quality and Master Data Management.

Set Mapping variable in Expression and use it in Source Filter

I have two tables in different databases. In a table A is the data, in the other table B are …

informatica informatica-powercenter
Search Informatica for text in SQL override

Is there a way to search all the mappings, sessions, etc. in Informatica for a text string contained within a …

informatica
How to attach a flat file into informatica Email?

I want to send a mail to some users after workflow is done. This email should contain 3 xls file or 1 …

email attachment xls email-attachments informatica
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 …

etl informatica-powercenter informatica
"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 …

ssis metadata etl informatica ab-initio
What are the types of datatypes in informatica and range of values they can take

I was trying to load data into db using informatica, where i used function to_integer() but it threw error …

informatica informatica-powercenter informatica-powerexchange
What is the difference between Informatica parameters?

What is the difference between $myvar and $$myvar parameters in Informatica PowerCenter?

informatica informatica-powercenter
Informatica writes rejected rows into a bad file, how to avoid that?

I have developed an Informatica PowerDesigner 9.1 ETL Job which uses lookup and an update transform to detect if the target …

data-warehouse etl informatica informatica-powercenter
Informatica Repository Query to get Workflow, Session, Mapping and Source/Target of Mapping

for cleaning up unused IPC-Sources I need a Repository Query for getting Workflow, Session, Mapping and Source/Target of Mapping.…

informatica informatica-powercenter
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 …

informatica informatica-powercenter