Informatica allows end users and partners to extend the metadata stored in the repository by associating information with individual objects in the repository. For example, when you create a mapping, you can store your contact information with the... Read More

1. Connected lookup 2. Unconnected lookup Connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values.it does not contain retun port. Unconnected lookup can return only one column.... Read More

ETL Tool: It is used to Extract(E) data from multiple source systems(like RDBMS,Flat files,Mainframes,SAP, XML etc) transform(T) them based on Business requirements and Load(L) in target locations.(like tables,files etc). Need of ETL Tool: ... Read More

One foolproof method is to maintain a field called ’Last Extraction Date’ and then impose a condition in the code saying ’current_extraction_date > last_extraction_date’. Read More

Specify the Full path of the Shell script the "Post session properties of session/workflow". Read More

Full Load: completely erasing the contents of one or more tables and reloading with fresh data. Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule. Read More

A mapping represents dataflow from sources to targets. A mapplet creates or configures a set of transformations. A workflow is a set of instruction sthat tell the Informatica server how to execute the tasks. A worklet is an object that represents a... Read More

Here are some popular versions of Informatica. Informatica Powercenter 4.1, Informatica Powercenter 5.1, Powercenter Informatica 6.1.2, Informatica Powercenter 7.1.2, Informatica Powercenter 8.1, Informatica Powercenter 8.5, Informatica Powercenter... Read More

ETL - The process of extracting data from multiple sources.(ex. flat files,XML, COBOL, SAP etc) is more simpler with the help of tools. Manual - Loading the data other than flat files and oracle table need more effort. ETL - High and clear... Read More

PowerCenter - ability to organize repositiries into a data mart domain and share metadata across repositiries. Read More

Active transformation can change the number of rows that pass through it. (decrease or increase rows) Passive transformation can not change the number of rows that pass through it. Read More

The ANALYZE statement allows you to validate and compute statistics for an index, table, or cluster. These statistics are used by the cost-based optimizer when it calculates the most efficient plan for retrieval. In addition to its role in... Read More

The best procedure to take a help of debugger where we monitor each and every process of mappings and how data is loading based on conditions breaks. Read More

Yes,we can override a native sql query in source qualifier and lookup transformation. In lookup transformation we can find "Sql override" in lookup properties.by using this option we can do this. Read More

No, In Informatica 5.2 and Yes, in Informatica 6.1 and later. Read More

Full Load: completely erasing the contents of one or more tables and reloading with fresh data. Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule. Read More

Informatica Metadata is data about data which stores in Informatica repositories. Read More

Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table. Snapshots are mirror or replicas of tables. Views are built using the columns from one... Read More

Rejection of records either at the database due to constraint key violation or the informatica server when writing data into target table.These rejected records we can find in the badfiles folder where a reject file will be created for a session.we... Read More

When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current mth) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an... Read More

1. PowerMart Designer 2. Server 3. Server Manager 4. Repository 5. Repository Manager Read More

Aggregator Transformation Expression Transformation Filter Transformation Joiner Transformation Lookup Transformation Normalizer Transformation Rank Transformation Router Transformation Sequence Generator Transformation Stored... Read More

A few are .... - Abinitio - DataStage - Informatica - Cognos Decision Stream - Oracle Warehouse Builder - Business Objects XI (Extreme Insight) - SAP Business Warehouse - SAS Enterprise ETL Server Read More

If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected Read More

ETL tool is ment for extraction data from the legecy systems and load into specified data base with some process of cleansing data. ex: Informatica,data stage ....etc OLAP is ment for Reporting purpose.in OLAP data avaliable in Mulitidimectional... Read More

A few more ... - Cognos Decision Stream - Oracle Warehouse Builder - Business Objects XI (Extreme Insight) - SAP Business Warehouse - SAS Enterprise ETL Server Read More

we cant directly import the xml file in informatica. we have to define the microsoft excel odbc driver on our system. and define the name in exce sheet by defining ranges. then in inforematica open the folder using sources ->import from... Read More

A data warehouse can be thought of as a three-tier system in which a middle system provides usable data in a secure way to end users. On either side of this middle system are the end users and the back-end data stores. Read More

You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup. Read More

dddf Read More

The Latest Version is 7.2 Read More

Data staging is actually a collection of processes used to prepare source system data for loading a data warehouse. Staging includes the following steps: Source data extraction, Data transformation (restructuring), Data transformation (data... Read More

There are various ways of Extracting Data from Source Systems.For example , You can use a DATA step, an Import Process .It depends with your input data styles. What kind of File/database it is residing in. Storing ur data in an ODS can be done thru... Read More

Parameter file defines the value for parameter and variable used in a workflow, worklet or session. Read More

Additve: A masure can participate arithmatic calulatons using all or any demensions. Ex: Sales profit Semi additive: A masure can participate arithmatic calulatons using some demensions. Ex: Sales amount Non Additve:A masure can’t ... Read More

Materialized view is a view in wich data is also stored in some temp table.i.e if we will go with the View concept in DB in that we only store query and once we call View it extract data from DB.But In materialized View data is stored in some temp... Read More

Yes. we can use mapping variable in Informatica. The Informatica server saves the value of mapping variable to the repository at the end of session run and uses that value next time we run the session. Read More

If you use PowerCenter, you can increase the number of partitions in a pipeline to improve session performance. Increasing the number of partitions allows the Informatica Server to create multiple connections to sources and process partitions of... Read More

ODS - Operational Data Store. ODS Comes between staging area & Data Warehouse. The data is ODS will be at the low level of granularity. Once data was poopulated in ODS aggregated data will be loaded into into EDW through ODS. Read More

Full Load: completely erasing the contents of one or more tables and reloading with fresh data. Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule Read More

1.Use filter condition in source qualifies with out using filter 2.use persistence and shared cache in look up t/r 3.use in aggregations t/r in sorted i/p,group by ports 4.in expression use operators instead of functions 5.increase the cache size 6... Read More

Yes, you can use advanced external transformation. for more detail you can refer the manual of informatica transformation guide in that advance external transformation. You can use c++ language on unix and c++, vb vc++ on windows server. Read More