Provide an example of a complex data transformation scenario you've implemented using BODI.
- 1 Answers
- 93 Views
- I also Faced
- E-Mail Answers
Answer Posted / Ajai Kumar Dwivedi
In one project, we had to combine data from multiple tables in an Oracle database, perform calculations, and aggregate results. The source tables contained customer details, order history, and product information. To achieve this, we created a job that used SQL scripts for transformation, joining tables on specific columns, applying business rules (e.g., calculating total sales), and grouping by certain attributes (e.g., customer or product). Finally, the aggregated data was exported to a CSV file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
