HP Informatica Interview Questions Collection.
- Explain what is the difference between PowerCenter and PowerMart in Informatica?
- What is the purpose of using UNIX commands in Informatica. Which UNIX commands are generally used with Informatica.Can you explain in brief.
- When should you create the dynamic data store? Do you require a DDS at all for this?
- Which SDLC suits best for the data warehousing project?
- Can a source qualifier be used to perform a outer join when joining 2 database?
- Explain what is the difference between static cache and dynamic cache?
- Explain how can you complete unrecoverable sessions in Informatica?
- How can you handle two sessions in Informatica?
- can you explain how the Informatica server increases the session performance through partitioning the source?
- How do we run a workflow without using GUI i.e, Worlflow Manager, Workflow Monitor and pmcmd?
- In what all transformations the mapplets cant be used in Informatica??
- What are mapping parameters and varibles in which situation we can use it
- What are the different types of Commit intervals available?
- Can you tell me what are the tasks that Loadmanger process will do?
- What does the first column of bad file (rejected rows) indicate? Explain in brief.
- What do you mean by Code Page Compatibility in Informatica?
- What do you mean by key factor in BRD?
- What is Strategy Transformation in Informatica?
- What is the difference between Rank and Dense Rank?
- Can you tell me what is the Rankindex in Ranktransformation in Informatica?
- When the informatica server marks that a batch is failed?
- Which tool you use to create and manage sessions and batches and to monitor and stop the informatica server?
- Can any one explain real time complain mappings or complex transformations in Informatica.Specially in Sales Domain.
- Please describe the Advantages and Disadvantages of star & snowflake schema?
- Explain how can you create or import flat file definition in to the warehouse designer?
- How do you identify existing rows of data in the target table using lookup transformation?
- How the Informatica server sorts the string values in Ranktransformation?
- How to use incremental aggregation in real time?
- In which circumstances that Informatica server creates Reject files?
- What do you mean by mapplets in Informatica?
- What are the different types of locks available in Informatica?
- Can you tell me what are the tasks that source qualifier performs?
- What exactly is a shortcut and how do you use it?
- Explain why is Code Page used for in Informatica?
- What do you mean by Load Manager in Informatica?
Related Posts
No comments :