Datastage Online Training
Download as PPTX, PDF
0 likes627 views
SVR Technologies provides you the best online learning experience that you ever had. Our trainers are having a real time experience of more than 8 years, they are working professionals and industry level experts. We offer all IT software courses for the lowest price with a quality assured training. For more info visit http://svrtechnologies.com/datastage_training.html
Datastage Online Training
- 1. Contact: 091-9885022027 Email: info@svrtechnologies.com Course name: Datastage Trainer: Kiran kumar Duration: 30 Hrs Session: Daily 1 Hr
- 2. Data Warehousing Concepts Topic1: Introduction to Data Warehousing What is Data Warehousing .Who needs Data Warehousing? Why Data Warehouse is required? Data Warehousing Architecture Types of Systems OLTP OLAP Data Warehousing Life Cycle.
- 3. Topic 2: Data Modeling Concepts Source Integration Layer Staging Area Target Analysis & Reporting ODS.
- 4. Topic 3: Multi-Dimensional Modeling Concepts What is dimension modeling? Difference between ER modeling and dimension modeling What is a Dimension? What is a Fact? Start Schema Snow Flake Schema Difference between Star and snow flake schema Continued in the next slide
- 5. Fact Table Different types of facts Dimensional Tables Fact less Fact Table Confirmed Dimensions Junk Dimensions Degenerative Dimensions What are slowly changing Dimensions? Different types of SCDs.
- 6. IBM DataStage Tool Topic 4: IBM DataStage Contents Introduction about Data Stage DataStage architecture Difference between Server Jobs and Parallel Jobs Difference between Pipeline Parallelism and Partition Parallelism Partition techniques Configuration File Difference between SMP/MPP Architecture Data stage components (Server components /Client components).
- 7. Topic 5: Administrator Introduction about Administrator Project creation and project properties setup.
- 8. Topic 6: Designer Introduction about Designer Repository Palette Type of Links.
- 9. Topic 7: File Stages Sequential file Dataset file File set Lookup file set Difference between Sequential file/Dataset/File set.
- 10. Topic 8: Database Stages Dynamic RDBMS Oracle Enterprise ODBC Enterprise.
- 11. Topic 9: Processing Stages Aggregate Stage Transformer Stage Surrogate Generator Stage Join Stage Merge Stage Lookup Stage Difference between Join/Lookup/Merge Difference between Join/Lookup Continued in the next slide
- 12. Remove Duplicates Switch Pivot Modify Funnel Different types of sorting and sort stage. Different types of combining and collecting techniques. Filter External filter Difference between filter, External filter and switch stages. SCD stage Adding job parameters to a job Parameter set Run time column propagation.
- 13. Topic 10: Debugging Stage Head Tail Pea Row Generator Column Generator Sample.
- 14. Topic 11: Data stage Director Introduction to Data stage Director Job Status View View logs Scheduling.
- 15. Thank You