⟩ How do you use automatic PGA memory management with Oracle 9i and above?
Set the WORKAREA_SIZE_POLICY parameter to AUTO and set PGA_AGGREGATE_TARGET
Set the WORKAREA_SIZE_POLICY parameter to AUTO and set PGA_AGGREGATE_TARGET
What are parameter files? Where do we use them?
How can we use mapping variables in Informatica? Where do we use them?
What is a mapping, session, worklet, workflow, mapplet?
What is Informatica Metadata and where is it stored?
How do we call shell scripts from informatica?
Can Informatica load heterogeneous targets from heterogeneous sources?
What are the different Lookup methods used in Informatica?
What are active transformation / Passive transformations?
What are the modules in Power Mart?
Compare ETL & Manual development?