Informatica Tool Interview Questions.
Professionals are invited to share the answers in the comment section.
- Explain how do we load fact table in Informatica?
- What the dimension load methods in Informatica?
- What do you mean by a view? How it is related to data independence?And what are the different types of views,and What is Materialize view
- What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in
- Work flow monitor in Informatica?
- What do you mean by Repository size, what is its min and max size?
- Explain what is the difference between Informatica Powercenter server, repository server and repository?
- What is the main difference between using an object from shared folder and copying an object and using that copied object ?
- What kind of Update strategies are normally used for (Type 1, 2 & 3) and what are the differences?
- Can you start a batches with in a batch?
- How can we eliminate duplicate rows from flat file?
- Explain how do you automatically execute a batch or session?
- How many minimum groups can be defined in a Router transformation?
- How to load the data from people soft HRM to people soft ERM using Informatica?
- In a flat file SQL override will work are not? What is the extension of flatfile?
- What about rapidly changing dimensions?Can you analyze with an example?
- What is aggregate awareness in Informatica?
- What is granularity in INFORMATICA? How should be the level of granularity for a fact table as well as for a dimension table?
- What do you mean by Router transformation in Informatica?
- What is the difference between Informatica repository server & Informatica server
- What is TOAD and for what purpose it will be used in Informatica?
- Can you write a query to retrieve the latest records from the table sorted by version(scd).
- Can you start a session inside a batch individually?
- Explain how can we eliminate source bottleneck using query hint
- How can you change change column to row in Informatica
- How many number of sessions that You can create in a batch?
- How to load the time dimension using Informatica ?
- In a joiner transformation, you should specify the source with fewer rows as the master source.Why?
- What are 2 modes of data movement in Informatica Server?
- What is aggregate cache in aggregator transforamtion?
- What do you mean by grouped cross tab in Informatica?
- What is semi-additive measures and fully additive measures?
Related Posts
No comments :