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.
- How many types of dimensions are available in Informatica?
- How to move the mapping from one database to another?
- How can you create a mapping using multiple lookup transformation?
- 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 mapping parameters or variables created in one maping into another maping?
- Explain about the designer tools for creating transformations?
- What are the rank caches in Informatica?
- What are variable ports and list two situations when they can be used?
- What is associated port in look up.
- Explain about the incremantal aggregation in Informatica?
- What do you mean by a session recovery in Informatica?
- Explain what is the main difference between Normal 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 mapping parameters or variables created in one maping into any other reusable transformation?
- Explain how can we partition a session in Informatica?
- How do you create single lookup transformation using multiple tables?
- How many types of facts are there Informatica 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?
- Explain about the 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.
- Explain about the various types of Aggregation?
- What do you mean by a authenticator in Informatica?
- 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 does session mean in Informatica?
- Explain what is the difference between next value and current value ports in sequence generator?\
- Differentiate between source and target object definitions in Informatica?
Related Posts
No comments :