we have around 300 reports and are currently using extracts created from teradata, now we're planning to migrate data to hadoop with keeping same table structure wherever possible;
question is how best we can update dashboards to change in data source with minimal impact on dashboard redevelopment: as in some extracts we have star schema model where one fact is connected to 6-8 dimensions:
if table and column structure is same, then open extract in desktop and edit connection at extract level works - edit connection from teradata server to hadoop:- will join defined betweeen tables be there or they going to break
we need to create new extract and do replace data source -option
we need to perform this with minimum impact dashboards or with less redevelopment efforts: any better solutions other than above...