Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Mapping Fields
#1
Hi Team,

I have 6 SQL Cubes in an ETL, each Cube has various dimensions and measures fields. Each cube has a total of 800 parameter/fields.

These Cubes are dependent on different OLTP applications (which have their own databases locally). I am using report builder to as BI tool to validate the Cube Data matches the orignal OLTP application database. The challenge is many fields name in the cub is slightly different from the original field.

Can I use python to learn how to map my Cube Fields with the Local SQL table fields so it is easier to get the right fields in Report builder instead of searching 800 fields manually.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Mapping a value to an interval JazonKuer 12 1,846 Mar-17-2023, 07:59 PM
Last Post: Gribouillis
  access is denied error 5 for network drive mapping ? ahmedbarbary 2 1,731 Aug-17-2022, 10:09 PM
Last Post: ahmedbarbary
  Compare fields from two csv files georgebijum 3 1,335 Apr-25-2022, 11:16 PM
Last Post: Pedroski55
  Mapping a range ebolisa 5 3,416 Jun-12-2021, 11:17 PM
Last Post: ebolisa
  Json fields not being retrieved mrcurious2020 4 1,989 Sep-14-2020, 06:24 AM
Last Post: bowlofred
  mapping joystick axis to specific 'channels' in python DashOrion 1 2,553 Jul-07-2020, 04:26 PM
Last Post: DashOrion
  mapping-camera-coordinates-to-a-2d-floor-plan fauveboyxuuki 0 2,494 Dec-10-2019, 10:34 PM
Last Post: fauveboyxuuki
  Maze Mapping with Image Processing furkankuyumcu 0 2,162 Dec-16-2018, 02:45 PM
Last Post: furkankuyumcu
  Python Idea Assist.: BerryIMU & Raspberry Pi 3 Audio Mapping StephLeber 0 2,262 Dec-09-2018, 10:43 AM
Last Post: StephLeber
  Python Inbuilt library for XAML to HTML5 mapping adityamandlekar 1 2,345 Jun-07-2018, 08:05 AM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020