Hi all,
My source is HIVE and Target is Azure SQL Server. I am trying to use a query source from hive. But in column mapping page instead of column names it shows as tablename.columnname, hence it can not do the column mapping automatically. Any idea why this is happening? example if source table is T1 in the column mapping page it looks like this after manual mapping
T1.C1----->C1
T1.C2----->C2
Have huge tables with 200+ columns, it would be a pain if I do the manual mapping.
Thanks in advance