Overview:Informatica Interview Papers Collection,Professionals are invited to share Answers for these Informatica Interview Questions,Learn by sharing Informatica Interview Questions asked in various companies
DatawareHousing Interview Questions and Answers
| Informatica Interview Questions | Datastage Interview Questions |
| Ab Initio Interview Questions | Business Objects Interview Questions |
| Reportnet Interview Questions | Hyperion Interview Questions |
How do you create a mapping using multiple lookup transformation?
How many types of dimensions are available in Informatica?
How to move the mapping from one database to another?
In a session log file where can you find the reader and the writer details?
What are bitmap indexes and how and why are they used?
After dragging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
Can you use the maping parameters or variables created in one maping into another maping?
How can we join the tables if the tables have no primary and forien key relation and no matchig
port to join?
What are the designer tools for creating tranformations?
What are the rank caches?
What are variable ports and list two situations when they can be used?
What is associated port in look up.
What is incremantal aggregation?
What is session recovery?
What is the difference between Narmal load and Bulk load?
What is the optimum method to load five flat files with same structures into target?
What will be the way to send only duplicate records to the Target?
Which all databases PowerCenter Server on UNIX can connect to?
Are you involved in high level low level design? What is meant by that high level design n low
level design?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
How can we partition a session in Informatica?
How do you create single lookup transformation using multiple tables?
How many types of facts and what are they?
How to parse characters using functions in the expression transformation. For example if a
column has character like mgr=a. I have to parse the character 'mgr='. Which function should I use?
In a Type 1 mapping with one source and one target table what is the minimum number of update strategy transformations to be used?
What are Connected and Unconnected Lookups?
What are the difference between joiner transformation and source qualifier transformation?
What are the real time problems generally come up while doing/running mapping/any
transformation?can any body explain with example.
What are various types of Aggregation?
What is authenticator?
What is incremental loading in Informatica(that is used to load only updated information in the
source)?How and where you use it in Informatica?
What is session?
What is the difference between next value and current value ports in sequence generator?
What is the output for different groups in case of router transformation ifi. 1--Aii.2--Biii.3--A or
Biv. 4--A and Bv.5--Default
What's the difference between source and target object definitions in Informatica?
0 comments on "Informatica Technical Questions Collection"
Post a Comment