Informatica Interview Questions asked in top MNCs, Informatica Technical Interview Questions.
- Explain the procedure to write the query to list the highest salary of three employees?
- Under what circumstances do you we use dynamic cache and when do we use static cache in an connected and unconnected lookup transformation
- Can you tell me which objects cannot be used in a mapplet transformation in Informatica?
- By using Update Strategy Transformation we use to maintain historical data using Type2 &Type3. By both of this which is better to use and why?
- Describe the use of Materialized views and how are they different from a normal view.
- Explain how do you access the remote source into your session?
- How can you fine tune the mapping and what are the methods we follow for different types of transformations?
- How many ways you can create ports?
- Explain how do you recover the standalone session in Informatica?
- In Source Qualifier and in Target I have 1,2,3 row and I want to insert 4,5 records in source and I want them in target also? What is the procedure to load them?
- What do you mean by folders in Informatica?
- Explain in brief what are the different threads in DTM process?
- What are the steps followed in Informatica performance tuning ?
- What does reusable transformation mean. Can you explain?
- What do you mean by CDC in Informatica?
- What do you mean by IQD file in Informatica?
- What is sql override where do we use and which transformations
- Differentiate between PowerCenter 7 and PowerCenter 8?
- Explain the process of loading the time dimension?
- When Informatica 7.1.1 version was introduced into market
- Which one is better performance wise joiner or lookup
- Can a lookup be done on Flat Files in Informatica?
- What do you mean by SQL override? In which transformation we use override?
- Describe two levels in which update strategy transformation sets?
- Explain how can you call trigger in stored procedure transformation
- How do you handle decimal places while importing a flatfile into Informatica?
- How many worklets can be defined within a workflow in Informatica?
- How to retrieve the records from a rejected file. explane with syntax or example
- In update strategy target table or flat file which gives more performance ? why?
- What are main advantages and purpose of using Normalizer Transformation in Informatica?
- What are the different transformations where you can use a SQL override?
- What are the steps involved in to get source from OLTP system to staging area
- What does the expression n filter transformations do in Informatica Slowly growing target wizard?
- What do you mean by change data capture in Informatica?
- What is JMS and what is the relation between powerconnect and JMS?
Related Posts
No comments :