[sheetal dhore]

Originally Posted by shashi5

hi shwetha here are some questions for you
1 What is a staging area? Do we need it? What is the purpose of a
staging area?


2 When do we Analyze the tables? How do we do it?


3 What is the difference between Power Center & Power Mart?


4 What is partitioning? What are the types of partitioning?


5 What is latest version of Power Center / Power Mart?


6 What is Informatica Metadata and where is it stored?


7 What is Full load & Incremental or Refresh load?


8 What is a three tier data warehouse?


9 What is a mapping, session, worklet, workflow, mapplet?


10 What are the various transformation available?


11 What are the various tools? - Name a few


12 What are the various methods of getting incremental records or
delta records from the source systems?


13 What are the modules in Power Mart?


14 What are the different Lookup methods used in Informatica?


15 What are snapshots? What are materialized views & where do we use
them? What is a materialized view log?


16 What are parameter files ? Where do we use them?


17 What are active transformation / Passive transformations?


18 Techniques of Error Handling - Ignore , Rejecting bad records to
a flat file , loading the records and reviewing them (default values)


19 How to determine what records to extract?


20 How do we extract SAP data Using Informatica? What is ABAP? What
are IDOCS?


21 How do we call shell scripts from informatica?


22 How can we use mapping variables in Informatica? Where do we use
them?


23 Do we need an ETL tool? When do we go for the tools in the
market?


24 Compare ETL & Manual development?


25 Can we use procedural logic inside Infromatica? If yes how , if
now how can we use external procedural logic in informatica?


26 Can we override a native sql query within Informatica? Where do
we do it? How do we do it?


27 Can Informatica load heterogeneous targets from heterogeneous
sources?