1. What is a staging area? Do we
need it? What is the purpose of a staging area?
2. What is a three-tier data
warehouse?
3. What are the various methods
of getting incremental records or delta records from the source systems?
4. What are the various tools? -
Name a few
5. What is latest version of
Power Center / Power Mart?
6. What is the difference
between Power Center & Power Mart?
7. What are the various
transformation available?
8. What are the modules in Power
Mart?
9. What are active
transformation / Passive transformations?
10. What are the different
Lookup methods used in Informatica?
11. Can Informatica load
heterogeneous targets from heterogeneous sources?
12. How do we call shell scripts
from informatica?
13. What is Informatica Metadata
and where is it stored?
14. What is a mapping, session,
worklet, workflow, mapplet?
15. How can we use mapping
variables in Informatica? Where do we use them?
16. What are parameter files?
Where do we use them?
17. Can we override a native sql
query within Informatica? Where do we do it? How do we do it?
18. Can we use procedural logic
inside Infromatica? If yes how, if now how can we use external procedural logic
in informatica?
19. Do we need an ETL tool? When
do we go for the tools in the market?
20. How do we extract SAP data
Using Informatica? What is ABAP? What are IDOCS?
21. How to determine what
records to extract?
* Timestamps
* Deletes are logical with
timestamped deletes
* Triggers on source system
tables (Generally we dont do this as this decreases the source system
efficiency)
* Application Integration
Software TIBCO , MQSERIES
* File Compares (least method)
* Snapshots in Oracle(daily)
* Oracle Streams
22. What is Full load &
Incremental or Refresh load?
23. Techniques of Error Handling
- Ignore , Rejecting bad records to a flat file , loading the records and reviewing
them (default values)
24. What are snapshots? What are
materialized views & where do we use them? What is a materialized view log?
25. What is partitioning? What
are the types of partitioning?
26. When do we Analyze the
tables? How do we do it?
27. Compare ETL & Manual
development?
2. What is a three-tier data
warehouse?
3. What are the various methods
of getting incremental records or delta records from the source systems?
4. What are the various tools? -
Name a few
5. What is latest version of
Power Center / Power Mart?
6. What is the difference
between Power Center & Power Mart?
7. What are the various
transformation available?
8. What are the modules in Power
Mart?
9. What are active
transformation / Passive transformations?
10. What are the different
Lookup methods used in Informatica?
11. Can Informatica load
heterogeneous targets from heterogeneous sources?
12. How do we call shell scripts
from informatica?
13. What is Informatica Metadata
and where is it stored?
14. What is a mapping, session,
worklet, workflow, mapplet?
15. How can we use mapping
variables in Informatica? Where do we use them?
16. What are parameter files?
Where do we use them?
17. Can we override a native sql
query within Informatica? Where do we do it? How do we do it?
18. Can we use procedural logic
inside Infromatica? If yes how, if now how can we use external procedural logic
in informatica?
19. Do we need an ETL tool? When
do we go for the tools in the market?
20. How do we extract SAP data
Using Informatica? What is ABAP? What are IDOCS?
21. How to determine what
records to extract?
* Timestamps
* Deletes are logical with
timestamped deletes
* Triggers on source system
tables (Generally we dont do this as this decreases the source system
efficiency)
* Application Integration
Software TIBCO , MQSERIES
* File Compares (least method)
* Snapshots in Oracle(daily)
* Oracle Streams
22. What is Full load &
Incremental or Refresh load?
23. Techniques of Error Handling
- Ignore , Rejecting bad records to a flat file , loading the records and reviewing
them (default values)
24. What are snapshots? What are
materialized views & where do we use them? What is a materialized view log?
25. What is partitioning? What
are the types of partitioning?
26. When do we Analyze the
tables? How do we do it?
27. Compare ETL & Manual
development?
0 comments: