What is the difference between source qualifier transformations source filter to filter transformation?
What are the types of metadata that stores in repository?
What are the main issues while working with flat files as source and as targets ?
Explain what are the different types of transformation available in informatica.
what is the difference between repository & Intergration service
8.what is mapplet ?give example?
EXL informatica Questions
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
What is session task and command task?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How informatica process data means how informatica works?
How identifying bottlenecks in various components of informatica and resolving them?