Informatica ETL Tool Interview Questions ,Free Informatica Interview Questions.
- What are the new features and enhancements in PowerCenter 5.1?
- What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in Informatica.
- What is a repository?
- What is difference between stored procedure transformation and external procedure transformation?
- What is polling?
- What is the difference between active transformation and passive transformation?
- What is the exact syntax of an update strategy?
- What is update strategy and what are the options for update strategy?
- Why do we use reusable sequence generator transformation only in mapplet?
- Can we use lookup instead of join? Reason
- Give me an scenario where flat files are used?
- How do we do complex mapping by using flatfiles / relational database?
- How does sorted input works in aggregator transformation
- How to get 25 of 100 fields table is there any transformation available in Informatica I know router/filter or any other?
- If I done any modifications for my table in back end does it reflect in Informatica warehouse or mapping designer or source analyzer?
- To provide support for Mainframes source data,which files are used as a source definitions? COBOL files
- What are the common errors while running a Informatica session?
- What are the new features in Informatica 5.0?
- What are the various types of transformation?
- What is a shared folder?
- What is drill-down and drill-up?
- What is power center repository?
- What is the difference between connected and unconnected stored procedures.
- What is the file extension and format of the files for the Informatica objects like Mappings, sessions etc in the repository?
- What is update strategy transformation?
- Why do you use a reusable sequence generator transformation in mapplets?
- Can we use lookup transformation with out using source qualifier transformation?
- Have you implemented Lookup in your mapping, If yes give some example?
- How do we do unit testing in Informatica?How do we load data in Informatica ?
- How does the Informatica know that the input is sorted?
- How to get the first 100 rows from the flat file into the target?
- If index cache file capacity is 2MB and data cache is 1 MB. If you enter the data of capacity for index is 3 MB and data is 2 MB. What will happen?
- Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
- What are the common problems developers face while ETL development
- What are the new features of the server manager in the Informatica 5.0?
Related Posts
No comments :