Informatica Interview Questions
- What r the joiner caches?
- How to load time dimension?
- What is power center repository?
- What is Informatica basic data flow?
- Can you start a batches with in a batch?
- What is Data Transformation Manager?
- What is update strategy transformation?
- Where is the cache stored in informatica?
- Difference between Rank and Dense Rank?
- Why we use stored procedure transformation?
- What r the tasks that source qualifier perform?
- How do we analyse the data at database level?
- What are the join types in joiner transformation?
- How i can do incremental aggregation in real time?
- Why we use partitioning the session in informatica?
- What r the types of groups in Router transformation?
- How many types of flat files available in Informatica?
- What is the default join that source qualifier provides?
- When and how a partition is defined using Informatica?
- What is the difference between Informatica 7.0 and 8.0?
- What are Dimensions and various types of Dimensions?
- What are the designer tools for creating transformations?
- What are the unsupported repository objects for a mapplet?
- Why did you use stored procedure in your ETL Application?
- How many types of dimensions are available in Informatica?
- How to get the first 100 rows from the flat file into the target?
- How many numbers of sessions that you can create in a batch?
- How u will create header and footer in target using informatica?
- What is the difference between filter and lookup transformation?
- What are the basic needs to join two sources in a source qualifier?
- What are two types of processes that informatica runs the session?
- What is rank transformation? Where can we use this transformation?
- How do you create a mapping using multiple lookup transformation?
- How can you improve the performance of Aggregate transformation?
- Discuss the advantages & Disadvantages of star & snowflake schema?
- What are the different options used to configure the sequential batches?
- Which ETL tool is more preferable Informatica or Data Stage and why?
- Diff between static and dynamic cache? And please explain with one example?
- What is the difference between informatics 7x and 8x and what is latest version?
- How do you handle decimal places while importing a flat file into informatica?
- How do we do unit testing in informatica? How do we load data in informatica?
- Where to store informatica rejected data? How to extract the informatica rejected data?
- Why have you applied for an Informatica job? What sort of a career are you aiming for?
- What does the expression n filter transformation do in Informatica Slowly growing target wizard?
- Whats the diff between Informatica power center server, repository server and repository?
- In a joiner transformation, you should specify the source with fewer rows as the master source. Why?
- What are main advantages and purpose of using Normalizer Transformation in Informatica?
- How can you recognise whether or not the newly added rows in the source are gets insert in the target?
- How will u get information about bugs how will u rectify the bugs in real time which tool we are using to rectify the bugs?
- In a scenario I want to change the dimensions of a table and normalize the renormalized table which transformation can I use?