Informatica Technical Interview Questions and FAQs.
- Explain what is a code page in Informatica?
- What do you mean by Data Transformation Manager?
- What is meant by Junk Attribute in Informatica?
- Explain what is the advantages of converting stored procedures into Informatica mappings?
- Explain what is the difference between static cache and dynamic cache ?
- What is the Technical reason for having Source Qualifier in Informatica? Can a mapping be implemented without it?
- Where from we get the source data or how we access the source data?
- While importing the relational source definition from database, what are the meta data of source you import?
- Can identify existing rows of data using unconnected lookup transformation.
- Explain about Recovering sessions in Informatica?
- How can you join two tables without using joiner and SQL override transformations?
- How do you measure slowly changing dimensions using lookup table
- How to create primary key only on odd numbers?
- How Union Transformation is used in Informatica?
- Is it possible to execute work flows in different repositories at the same time using the same Informatica server?
- What are steps involved in connecting OLTP system to DATAWARE HOUSE to get the source from OLTP system
- What are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version? 471. explain use of update strategy transformation
- What are the types of groups in Router transformation?
- Tell me the command command that used to run a batch?
- What do you mean by Datadriven in Informatica?
- Explain what do you mean by lookup caches in Informatica?
- What is the architecture of any Data warehousing project? What is the flow?
- Explain what is the difference between STOP & ABORT in INFORMATICA session level ?
- Why do you use auxiliary mapping in Informatica?
- Where is the cache stored in Informatica?
- While running a session what default files are created?
- Can Informatica be used as a Cleansing Tool? If Yes, give example of transformations that can implement a data cleansing routine.
- Explain about scheduling real time in Informatica.
- How can you migrate Mappings and Sessions from Informatica 6.2 to Informatica 7.1?
- How can you migrate from one environment to another like development to production in Informatica.
- Explain how can you create slowly changing dimension in Informatica?
- How do we validate all the mappings in the repository at once
- Is it possible to refresh the Materialized view in Informatica?
- What are Target definitions in Informatica?
- What are the general reasons of session failure with Look Up having Dynamic Cache?
Related Posts
No comments :