-
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...
-
Session Termination Error
What is session termination? Why does this error occur?
-
Informatica Integration Service
How many Integration Service does Informatica Server contain? only one or many? Explain
-
Router Trasmission Logic Expression
What are the logic expression used in router trasmission?
-
-
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 Loop Scope
How to perform a "Loop Scope / Loop condition" in an Informatica program ? Give me few examples.
-
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
-
Workflow Dependancy
Where do we set the dependancy in the workflow?
-
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
Ans