- What is ETL (Extract, transform, Load)?
- What is Lookup transformation?
- What is Informatica?
- What is the difference between active and passive transformation?
- Why is sorter an active transformation?
- What is the use of source qualifier?
- What is shared cache?
- What is re cache?
- How can we filter rows in Informatica?
- How can we update a record in the target table without using Update Strategy?
- Define the surrogate key.
- Define OLAP.
- What are the different types of OLAP?
- What is target load order?
- Define Target Designer.
- Define junk dimensions.
- What is Rank Transformation?
- What is Sequence Generator transformation?
- What is the use of aggregator cache file?
- How are indexes created after completing the load process?
- What is the difference between mapping parameter and mapping variable?
- What is a Repository Manager?
- What is Workflow Manager?
- What is Load Order?
- What is a Dimensional Model?
- What is Fact Table? What are the different kinds of Fact Tables?
- What is Decode in Informatica?
- What is SUBSTR?
- What is code page compatibility?
- What is Aggregator transformation?
- What is Expression transformation?
- What is Joiner transformation?
- What is incremental aggregation?
- What is a mapplet?
- What is reusable transformation?
- What is surrogate key?
- What is a session task?
- What is a command task?
- What is a predefined event?
- What is a user-defined event?
- What is Sequence Generator transformation?
- What is Connected LookUp & Unconnected LookUp?