Informatica Interview Questions and Data Warehouse Interview Questions.
- Explain what is data merging, data cleansing, sampling?
- What do you mean by complex mapping in Informatica?
- What do you mean by target load order in Informatica?
- What is the difference between SQL override in Source Qualifier and SQL override in Look up transformation.
- What do you mean by status code in Informatica?
- Where do you define update strategy?
- Which transformation should you need when using the COBOL sources as source defintions?
- Can you start and stop single session in concurrent bstch?
- Explain about Informatica server process that How it works relates to mapping variables?
- Explain in detail how can you improve the performance of Aggregate transformation?
- How do you load the time dimension in Informatica?
- How do you create a custom transformation, can you give a realtime example where exactly you have used it.
- Explain how do you work with pmcmd on windows platform?
- What do you mean by Shortcuts in Informatica?
- What are the different ways you can employ to filter rows using Informatica transformations?
- What are the types of data flows in workflow manager
- What happens when the session stops half way while loading? How to join a flat file without matching keys in RDBMS?
- What is meant by EDW in Informatica?
- What is Target Update Override in Informatica? What is its usage?
- Explain in brief what is the difference between SQL Overriding in Source qualifier and Lookup transformation?
- Explain what do you mean by Source definitions in Informatica?
- Explain about target load order?
- Where does the records goes which does not satisfy condition in filter transformation?
- While importing the relational source definition from database, what are the meta data of source that you import?
- Can you use a session Bulk loading option that time can you make a recovery to the session?
- Explain about perform recovery in Informatica?
- How can you join two or more tables without using the source qualifier override SQL or a Joiner transformation?
- Explain the process of maintaining Historical data and how to retrieve the same?
- How do you create parameter file and How to use it in a mapping explain with example
- How do you write a filter condition to get all the records of employees hired between any two given dates.
- What is Data Modeling? What are the different types of Data Modeling?
- Can you tell me whether a fact table normalized or de-normalized?
- What are the difference between joiner transformation and source qualifier transformation?
- What are the types of data that passes between informatica server and stored procedure
Related Posts
No comments :