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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: ASUG New England fall meeting: Oct 27.

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
ThanksForHelp
Principal Member
Principal Member



Joined: 25 Sep 2006

Posts: 284



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

Hi,

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
aidelia
Principal Member
Principal Member



Joined: 02 Feb 2006

Posts: 334
Location: Rosario, Argentina


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

Hello,

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.

Regards,


Andrés
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4248
Location: Denver Area


flag
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
ErikR
Forum Enthusiast
Forum Enthusiast



Joined: 10 Jan 2007

Posts: 1089
Location: Wellington, NZ


flag
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.0159 seconds using 17 queries. (SQL 0.0077 Parse 0.0002 Other 0.0079)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo