| Author |
Message
|
| aradha |
 Posted: Tue Feb 23, 2010 2:47 am Post subject: Mapping |
 |
|
Apprentice
Joined: 16 Dec 2008
Posts: 45
|
Hi
I am doing mapping XML to TDS.
Is there any advantage of using ESQL for mapping instead of Mapping Node any ideas which is best????? |
|
| Back to top |
|
 |
| MrSmith |
| Posted: Tue Feb 23, 2010 2:56 am Post subject: |
|
|
Master
Joined: 20 Mar 2008
Posts: 215
|
| One thing i have always noticed between levesl is that Mappings seem always to need migrating whereas ESQL code rarely has. If the values are not manipulated much or conditioned then mapping would be a easy option but i would say ESQL has more flexibility. Unless you have a time constraint then do it in both see what gives!!! |
|
| Back to top |
|
|
| aradha |
| Posted: Tue Feb 23, 2010 3:04 am Post subject: |
|
|
Apprentice
Joined: 16 Dec 2008
Posts: 45
|
Thanks for reply just want to what exactly advantage of using ESQL
for mapping cases. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 23, 2010 5:08 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| aradha wrote: |
Thanks for reply just want to what exactly advantage of using ESQL
for mapping cases. |
The mapping node uses ESQL under the covers. If you have all the message sets you need and straightforward mapping requirements the mapping node is a good choice. For everything else use ESQL.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| aradha |
| Posted: Tue Feb 23, 2010 7:28 pm Post subject: Mapping |
|
|
Apprentice
Joined: 16 Dec 2008
Posts: 45
|
| For every thing else means?? for understanding can you give example |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 23, 2010 7:47 pm Post subject: Re: Mapping |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| aradha wrote: |
| For every thing else means?? |
For all those cases where you don't have all the message sets you need and/or have complex transformation requirements.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Bartez75 |
| Posted: Wed Feb 24, 2010 7:20 am Post subject: |
|
|
Voyager
Joined: 26 Oct 2006
Posts: 80
Location: Poland, Wroclaw
|
If you know ESQL then use it. If not then perhaps mapping is a good start.
I use always esql even if mapping is very simple because simply I don't feel comfortably with mapping node.
Since there is no performance differences between them (maybe I'm here) then the choice is rather simple. |
|
| Back to top |
|
|
|
|
