0 Replies Latest reply on Feb 14, 2020 9:26 PM by saps saps

    Teradata to hadoop migration

    saps saps

      hi All,

      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...

       

      thanks all