You are right. Things would go different depends on requirements. On my current project, we pulled records/tables from different sources and most issues are naming conventions (tables, columns) , data...

Thank you for your response and effort sir Lowell

Thank you Sir Lowell. I manage to check and run the report service via Report Services Configuration Manager. The Report Server is up and running.

Now,  I checked the Report Server...

This is what i am worrying about. If the identity key will be automated, the client would not be very concern to it and data lost will be common unless...

• This reply was modified 3 years, 6 months ago by  zysirhc.

Customers cannot have direct access to the DW.

Available records via Business Intelligence or visualization are the only access level they could be delegated. Datasets are prepared by data analyst or...

Yes sir, the PIT records would really be a challenging data to handle. I'll design and implement a SCD type 6 for this section. I got confused on the work/history...