BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Oct 19.

source and target table mapping

Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
Principal Member
Principal Member

Joined: 25 Sep 2006

Posts: 290

PostPosted: Wed Oct 11, 2017 8:24 am 
Post subject: source and target table mapping


I have very simple DataFlow,

SQL -> query transformation-> Target table

The column name and order in Query transformation and target table are different, I need to do column mapping. Where can do this? I tried drag and drop it didn't work.

When I use temp table template it is working, but I need to load data to existing table and table is imported to the DataStore. Not sure what I am missing.

thanks in advance.
Back to top
Principal Member
Principal Member

Joined: 02 Feb 2006

Posts: 336
Location: Rosario, Argentina

PostPosted: Thu Oct 12, 2017 8:06 pm 
Post subject: Re: source and target table mapping


I'm not sure about the difficulties you have, since this seem a fairly simple task.

In short, in order to accompish the mapping you just have to change the name of the target columns in the query transform to match the names of the fields of the target table. By default, the target loading is done matching tha names of the fields, although I'd recommended that you respect the order of the fields (We've had some problems when doing Bulk loading). Also, is they are missing columns in the last query before the target, DS just warn of that and fill the target column with NULL.

I`d recommend you reread the tutorials or the SAP blogs and begginner's Guides if you still has problems with this.


Back to top
Forum Addict
Forum Addict

Joined: 12 Sep 2007
Posts: 4278
Location: Denver Area

PostPosted: Mon Oct 16, 2017 2:23 pm 
Post subject: Re: source and target table mapping

Start with just a source and target table in your Dataflow. Then add a Query transform but do not open it. Connect the target table to the Query transform first, then connect the source table. Now open the Query transform. The columns from the target table should be in the output schema of the Query transform. You'll need to do the mapping now.
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
Forum Enthusiast
Forum Enthusiast

Joined: 10 Jan 2007

Posts: 1108
Location: Wellington, NZ

PostPosted: Mon Oct 16, 2017 5:16 pm 
Post subject: Re: source and target table mapping

Are you using the Designer on your own laptop/workstation or are you using the Designer on a virtual server/client to which you use Citrix or RDP to connect to?

The Designer Client is a very old-school C++ application that uses a lot of hook calls into the Windows layer to fetch cursor positions, etc. This is how contextual copy and paste is achieved in the Designer Client for instance - there is a lot of polling between the Designer application and the Windows UI.

Why do I mention that? Because the Designer Client was created before the use of virtualized environments, Citrix and RDP became mainstream and it's not uncommon for the Designer Client to be problematic in Citrix/RDP environments especially when dealing with high latency issues.

Where I am getting at? It's not unusual in my experience to run into "drag and drop" issues in the Designer, especially in Citrix/RDP environments. Like dragging columns across but nothing get dragged - that could mean you're trying to do this too quickly. Try again and be slower.

Or dragging the columns across and they refuse to get added to the target schema. Or you drag a column across and the Designer refuses to come up with the "Insert Above, Insert Below" menu. Closing the Query Task and opening it again may help. Sometimes closing the Designer and opening again may help. That usually does it but sometimes I've had to create the columns and mappings manually as the Designer wouldn't budge at all - this was on an older version of DS 4.0 over a crappy WAN connection.

Erik Roelofs
Soltius NZ - SAP Gold Partner
"New Zealand's most trusted SAP provider"

SAP Certified Application Associate - Data Integration with SAP Data Services 4.x
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0309 seconds using 17 queries. (SQL 0.0030 Parse 0.0009 Other 0.0271)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo