Informatica topics

Informatica Power Center 9.1.0 Course Content
Data Warehousing Concepts:
1. Definitions
2. Characteristics of Data Warehouse.

a. Time Variant Database.
b. Non Volatile Database.
c. Subject Oriented Database.
d. Integrated Database.

3. Data warehouse Architecture.
4. Data Acquisition Concept.

a. Data Extraction.
b. Data Transformation.

5. Data Cleansing.
6. Data Scrubbing.
7. Data Merging.
8. Data Aggregation.

a. Data Loading.

9. Rules To Maintain Historical Data.
10. Initial Extraction.
11. Delta Extraction.
12. SCD-1.
13. SCD-2
14. SCD-3.
15. ER-Modeling.
16. Dimensional Modeling.
17. Data Warehousing Schemas:

a. Star Schema.
b. Snow Flake Star Schema.
c. Integrated Star Schema

18. Facts.

a. Additive Fact.
b. Semi Additive Fact.
c. Non Additive Fact.

19. Data Marts:

a. Top to Bottom Approach.
b. Bottom to Top Approach.

20. Difference between OLTP & OLAP.

INFORMATICA 9.X TOOL
22. Informatica Software Installation.
23. Informatica Architecture.
24. Informatica Power Center Repository Manager.
25. Folder Management.
26. Informatica Power Center Designer.

a. Source Analyzer.
b. Target Designer.
c. Transformation Developer.
d. Mapplet Designer.
e. Mapping Designer.

27. Relational Tables.
28. Flat Files.
29. XML Files.
30. All Transformations:

a. Source Qualifier.
b. Expression
c. Aggregator.
d. Filter.
e. Lookup.
f. Update Strategy.
g. Sequence Generator.
h. Stored Procedure.
i. Joiner.
j. Rank.
k. Normalizer.
l. Router.
m. Sorter.
n. Transaction Control Transformation.
o. Union.
p. XML Parser.
q. XML Generator.
r. XML Source Qualifier.

31. Mapping Parameters & Variables.
32. Look Up Cache.
33. Target Load Plan.
34. Wizards.
35. Debugging Concept.
36. Version Controlling.
37. Informatica Power Center Workflow Manager:
38. Tools:

a. Task Developer.
b. Work let Designer.
c. Workflow Designer.

39. All Tasks:

a. Session.
b. Command.
c. Decision.
d. Event Wait.
e. Event Raise.
f. Email.
g. Timer.
h. Assignment.
i. Work let.
j. Link.
k. Control.

40. Workflow Properties.
41. Scheduler.
42. Variables.
43. Parameter Files.
44. Events.
45. Session Properties.
46. Session Config Objects.
47. Session Mapping Connections.
48. Parallel Data Loading.
49. Sequential Data Loading.
50. Workflow Dependencies.
51. Push Down Optimization.
52. Incremental Aggregation.
53. Performance Tuning.

a. Partitioning Concept.
b. Bottle Necks.

54. Informatica Power Center Workflow Monitor.

a. Session Run Properties.
b. Session Log.