-
Informatica Load Manager
What is Load Manager? What is the use of it in Informatica. In which situations would you use it in realtime.
saithirumal
- Mar 26th, 2011
if i run session or workflow that start an DTM process.the main purpose of Load Manager or Balance Load Manager is to find out which node is ideal among the nodes then assign the session task to that ...
-
What is DTM? How would you use it in Informatica?
lpmca
- Mar 22nd, 2011
DTM is Data Transformation Manager. Integration Services are used to move data from source to target based on workflow and mapping metadata stored in the repository.Integration services will sta...
-
Check Existing Rows in Target with Joiner
How to check whether rows existed in target or not by using joiner?
surinr
- Mar 18th, 2011
Use a lookup transformation and compare the target record with source record for existence of the record in the target table.
-
What are Aggregate transformation?
Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.
Read Best Answer
Editorial / Best Answer
Answered by: Praveen vasudev
- Sep 12th, 2005
Aggregator transform is m uch like the Group by clause in traditional SQL.
this particular transform is a connected/active transform which can take the incoming data form the mapping pipeline and group them based on the group by ports specified and can caculated aggregate funtions like ( avg, sum, count, stddev....e.tc) for each of those groups.
From a performanace perspective if your mapping has an AGGREGATOR transform use filters and sorters very early in the pipeline if there is any need for them.
veepee
sivakp
- Mar 13th, 2011
1. Aggrigator transformation allows to perform aggrigate calculation, such as SUM, MAX, MIN, FIRST, LAST2. Aggrigator transformation allows to perform aggrigate calculation of group.
shr_4
- Oct 27th, 2010
To perform Group by calculations we use Aggregator Transformation.It perform calculations similar to Expression Transformation.But difference between both is that Aggregator Transform...
-
What is meant by EDW?
yugandhar.bo
- May 15th, 2006
EDW is Enterprise Datawarehouse which means that its a centralised DW for the whole organization.this apporach is the apporach on Imon which relies on the point of having a single warehouse/centr...
-
Joiner Transformation Limitations
What are limitations and delimitations of Joiner Transformation?
jyothi_rayala
- Feb 28th, 2011
Joiner transformation cannot be used in the below scenarios ? Both pipelines begins with the same original data source. ? Both input pipelines originates from the same source qualifier. ? Bo...
-
Oracle Sequence Generator and Informatica Sequence Generator
The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?
Baloo_nanduri
- Jul 25th, 2010
To answer precisely functionality of both is same and even both are at par w.r.t to performance but there are certain limitations Oracle sequence generator is a stored procedure which can be call from...
-
Semi Additive and Factless Fact Tables
Which scenario will use semi additive and factless fact tables?
yagneswarasankar
- Feb 18th, 2011
Semi Additive Facts:A Semi Additive fact is a measure in a table that can be summed up w.r.to some dimentions and can not be or does not have any meaning if we sum up the measure with respect to those...
-
Fast Record Append
Which is the faster way - Adding a record at the beginning of a file or adding a record at the end of a file? Explain
jayapraveen
- Feb 11th, 2011
Best way is to have a flag in the data to denote it is last row. =Powercenter reads till end of data and it reads in blocks, so it doesn't =expose the state of the last record.
Surya_prakash
- Feb 10th, 2011
Adding index in to source qualifier and drop the index in the target table.
-
SCD Transformation
Can we use both SCD Type1 and Type2 transformations in one mapping? If yes how?
Nagaraju Puppala
- Feb 9th, 2011
Yes,,We should use the both logics in a single mapping in the real time.When an organization maintainig the employee data..It should maintain all historical data like the salary, designations etc. and...
Nagaraju Puppala
- Feb 9th, 2011
Yes,You can create SCD1, SCD2 logic in a single mapping :)Considersd Employe Table: which contains the columns eno, ename, sal, designation, phone, address.while you are loading in to the warehouse ta...
-
Informatica Integration Service
How many Integration Service does Informatica Server contain? only one or many? Explain
-
Informatica Internal Processes of Integration
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
bpranayreddy
- Jan 5th, 2011
Integration service will in turn call DTM service if the task in a session which will take care of extraction and loading of data......for other sessions like email, cmd it will hand over the task to DM manager which takes care of it. IS just manages the show
-
What is the difference between power center and power mart?
1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?
pasupula.naidu
- Dec 31st, 2010
For mapping parameters create a notepad file like this way, Sysntax:------------- [foldername.WF:workflow_name.ST:session_name] $$para_name=valuefor session parameters,sysnatx:-----------[...
hundwanipankaj
- Apr 5th, 2010
Power Mart is a departmental version of Informatica for building, deploying, and managing data warehouses and data marts. Power center is used for corporate enterprise data warehouse and power mart is...
-
What are the steps to create a mapplet in mapplet designer?
pasupula.naidu
- Dec 31st, 2010
1. Tools->mappletdesigner->create->give a name2. From tr menu->create->mapplet input3.
In, mapplet input tr create required ports4. Create required group of tr like sorter,exp5.
Drag the ports from mapplet input to the tr6. Create mapplet output t/rand finally save the mapplet in the repository -
Informatica High Availability
What is High Availability in Informatica?
Suman Lohith Korrapati
- Dec 20th, 2010
High availability is a PowerCenter option that eliminates a single point of failure in a domain and provides minimal service interruption in the event of failure.This is basically acheived at configur...
-
Informatica and SAS Exit
-
Update Strategy
Explain update strategy transformation giving an example
naveenkumar2829
- Dec 9th, 2010
By default Informatica processes all rows as insert, but if you want to change it as per transormation logic then we have to use updata strategy transformation.
-
How to implement de-normalization concept in Informatica Mappings?
Anindya1281
- May 2nd, 2010
This can be done using str --> exp --> Agg --> exp --> targetsay src file:port1 port2A1 B1A1 B2A1 B3A2 B1A2 &nb...
-
Can any one please tell me the architecture of Informatica and please tell me the flow of data in Iinformatica?
jayapraveen
- Nov 21st, 2010
architecture of informatica is as follows11. Source Systems: Like Mainframe,Oracle,People soft,DB2.2. Landing tables: These are tables act like source. Usedfor easy to access, for backup purpose, as r...
opbang
- Sep 21st, 2006
Power Center Architecture can be divided into two sub Architecture 1. Informatica Repository Architecture2. Informatica Server Architecture. Server 1 - Oracle Databa...
-
Session Performance
How can we see the performance details about session run?
Informatica Interview Questions
Read Best Answer
Ans