Lesson 2: Virtual Views, Transformations, SQL, and Data Services
Lesson Overview
This lesson develops practical TIBCO Data Virtualization skills for virtual views, transformations, sql, and data services. Learners connect architecture and configuration with validation and troubleshooting.
Topics Covered
Physical and logical views
Joins, unions, filters, and transformations
SQL and query concepts
Procedures and parameters
Publishing data services
Reusable semantic models
Practical Activity
Create a configuration or design plan for physical and logical views.
Complete a guided exercise covering joins, unions, filters, and transformations.
Validate results and troubleshoot a scenario involving reusable semantic models.
Key Takeaways
Explain physical and logical views clearly.
Apply sql and query concepts in a practical workflow.
Use logs, tests, and validation steps to confirm expected behavior.
