Posted Under Informatica-Interview-Questions
What is a code page?
What is Data Transformation Manager?
What is meant by Junk Attribute in Informatica?
What is the advantages of converting stored procedures into Informatica mappings?
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
Can identify existing rows of data using unconnected lookup transformation.
Explain about Recovering sessions?
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?
Is it possible to execute work flows in different repositories at the same time using the same Informatica server?
What are steps invovlved 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?
What is a command that used to run a batch?
What is Datadriven?
What is meant by lookup caches?
What is the architecture of any Data warehousing project? What is the flow?
What is the difference between STOP & ABORT in INFORMATICA sess level ?
What is the use of auxiliary mapping?
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 do you migrate from one environment to another like development to production in
How to create slowly changing dimension in Informatica?
How we validate all the mappings in the repository at once
Is it possible to refresh the Materialized view?
What are Target definitions?
What are the general reasons of session failure with Look Up having Dynamic Cache?
Check all articles under Informatica-Interview-Questions