How to use ignore prefix and map the coluumns...

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
aschand
Participant
Posts: 57
Joined: Thu Jan 03, 2008 9:28 pm

How to use ignore prefix and map the coluumns...

Post by aschand »

Please can let me know how do I ignore prefix in the iput columns to map to o/p columns in the transformer stage..
What to write in it

thanks
aschand
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Can you give some example.. like what???
You can use Trim, or do substring and or many other functionality avaiable based on the exact requirment.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
aschand
Participant
Posts: 57
Joined: Thu Jan 03, 2008 9:28 pm

Post by aschand »

Here is the example

ABCD_EFGHI source side

EFGHI target side

now what should i put in ignore prefix inorder to auto match the column?

Thanks for ur help
kumar_s wrote:Can you give some example.. like what???
You can use Trim, or do substring and or many other functionality avaiable based on the exact requirment. ...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

ABCD_ on the source side.

Nothing on the target side.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply