Informatica FAQs, Interview Questions and Technical Interview Questions.
- Explain what do you mean by a source qualifier in Informatica? What is meant by Query Override?
- What do you mean by QTP in Data Warehousing?
- What is the difference between constrained base load ordering and target load plan
- Explain what is hierarchies in DWH?
- What do you mean by user defined Transformation?
- Why we use partitioning the session in Informatica?
- Can you copy the session to a different folder or repository?
- Explain how can we access MAINFRAME tables in INFORMATICA as a source ?
- How do we load data by using period dimension?
- Explain how is the union transformation active transformation?
- How to implement de-normalization concept in Informatica Mappings?
- Using unconnected lookup, how we you remove nulls and duplicates?
- What are the data movement modes in Informatica ?
- What are the properties should be notified when we connect the flat file source definition to relational database target definition?
- Explain what are two types of processes that Informatica runs the session?
- What do you mean by a surrogate key in Informatica ?
- Can you tell me what do you mean by a rank transformation?where can we use this transformation?
- What is the difference between constraints based load ordering and target load plan?
- What is the limit to the number of sources and targets you can have in a mapping
- Can you tell me what do you mean by version controlling?
- Why we use stored procedure transformation in Informatica?
- Explain how can we delete duplicate rows from flat files ?
- How can we load from PL/SQL script into Informatica mapping?
- How many Data marts are there in your project?
- How can you import oracle sequence into Informatica?
- If you are workflow is running slow in Informatica. Where do you start trouble shooting and what are the steps you follow?
- What is a time dimension? Please provide an example.
- What do you mean by Dynamic Data Store. Explain?
- Can you tell me what do you mean dynamic insert in Informatica?
- What do you mean by re-dimension in Informatica?
- Explain what is the difference between dynamic and static lookup?
- What do you mean by DTM session in Informatica?
Related Posts
No comments :