InfoSphere Optim

We are building some random lookup mappings using the out of the box UK address lookup tables.
Its basic stuff but for some reason if we try to use the Post Code or Post Town from the UK lookup table
it shows as in error in the column map. If we use Zip Code from the US lookup table it works. The other address columns all work.
I've seen the error reported elsewhere but no solution.

Anyone seen this?  or know the solution?

Using Optim designer for Siebel.

------------------------------
Andrew Crouch
------------------------------

#InfoSphereOptim
#Optim

Just spotted the recent discussion item on NVARCHAR and wonder if this is the same issue.

------------------------------
Andrew Crouch
------------------------------

Original Message:
Sent: 01-09-2019 06:42 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables


We are building some random lookup mappings using the out of the box UK address lookup tables.
Its basic stuff but for some reason if we try to use the Post Code or Post Town from the UK lookup table
it shows as in error in the column map. If we use Zip Code from the US lookup table it works. The other address columns all work.
I've seen the error reported elsewhere but no solution.

Anyone seen this?  or know the solution?

Using Optim designer for Siebel.

------------------------------
Andrew Crouch
------------------------------

#InfoSphereOptim
#Optim

What is the database?

------------------------------
Tulasi Uppu
------------------------------

Original Message:
Sent: 01-09-2019 06:50 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables

Just spotted the recent discussion item on NVARCHAR and wonder if this is the same issue.

------------------------------
Andrew Crouch

Original Message:
Sent: 01-09-2019 06:42 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables


We are building some random lookup mappings using the out of the box UK address lookup tables.
Its basic stuff but for some reason if we try to use the Post Code or Post Town from the UK lookup table
it shows as in error in the column map. If we use Zip Code from the US lookup table it works. The other address columns all work.
I've seen the error reported elsewhere but no solution.

Anyone seen this?  or know the solution?

Using Optim designer for Siebel.

------------------------------
Andrew Crouch
------------------------------

#InfoSphereOptim
#Optim

Hi,
    They are Oracle (unicode).
We are going to look at creating our own lookup tables in Siebel with matching datatypes.

------------------------------
Andrew Crouch
------------------------------

Original Message:
Sent: 01-10-2019 02:45 AM
From: Tulasi Uppu
Subject: Random Lookup issue using out of the box lookup tables

What is the database?

------------------------------
Tulasi Uppu

Original Message:
Sent: 01-09-2019 06:50 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables

Just spotted the recent discussion item on NVARCHAR and wonder if this is the same issue.

------------------------------
Andrew Crouch

Original Message:
Sent: 01-09-2019 06:42 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables


We are building some random lookup mappings using the out of the box UK address lookup tables.
Its basic stuff but for some reason if we try to use the Post Code or Post Town from the UK lookup table
it shows as in error in the column map. If we use Zip Code from the US lookup table it works. The other address columns all work.
I've seen the error reported elsewhere but no solution.

Anyone seen this?  or know the solution?

Using Optim designer for Siebel.

------------------------------
Andrew Crouch
------------------------------

#InfoSphereOptim
#Optim

With Oracle DB, you shouldn't have NVARCHAR issue.

------------------------------
Tulasi Uppu
------------------------------

Original Message:
Sent: 01-10-2019 04:46 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables

Hi,
    They are Oracle (unicode).
We are going to look at creating our own lookup tables in Siebel with matching datatypes.

------------------------------
Andrew Crouch

Original Message:
Sent: 01-10-2019 02:45 AM
From: Tulasi Uppu
Subject: Random Lookup issue using out of the box lookup tables

What is the database?

------------------------------
Tulasi Uppu

Original Message:
Sent: 01-09-2019 06:50 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables

Just spotted the recent discussion item on NVARCHAR and wonder if this is the same issue.

------------------------------
Andrew Crouch

Original Message:
Sent: 01-09-2019 06:42 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables


We are building some random lookup mappings using the out of the box UK address lookup tables.
Its basic stuff but for some reason if we try to use the Post Code or Post Town from the UK lookup table
it shows as in error in the column map. If we use Zip Code from the US lookup table it works. The other address columns all work.
I've seen the error reported elsewhere but no solution.

Anyone seen this?  or know the solution?

Using Optim designer for Siebel.

------------------------------
Andrew Crouch
------------------------------

#InfoSphereOptim
#Optim

Created our own lookups with same datatypes, they work fine.

------------------------------
Andrew Crouch
------------------------------

Original Message:
Sent: 01-10-2019 04:46 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables

Hi,
    They are Oracle (unicode).
We are going to look at creating our own lookup tables in Siebel with matching datatypes.

------------------------------
Andrew Crouch

Original Message:
Sent: 01-10-2019 02:45 AM
From: Tulasi Uppu
Subject: Random Lookup issue using out of the box lookup tables

What is the database?

------------------------------
Tulasi Uppu

Original Message:
Sent: 01-09-2019 06:50 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables

Just spotted the recent discussion item on NVARCHAR and wonder if this is the same issue.

------------------------------
Andrew Crouch

Original Message:
Sent: 01-09-2019 06:42 AM
From: Andrew Crouch
Subject: Random Lookup issue using out of the box lookup tables


We are building some random lookup mappings using the out of the box UK address lookup tables.
Its basic stuff but for some reason if we try to use the Post Code or Post Town from the UK lookup table
it shows as in error in the column map. If we use Zip Code from the US lookup table it works. The other address columns all work.
I've seen the error reported elsewhere but no solution.

Anyone seen this?  or know the solution?

Using Optim designer for Siebel.

------------------------------
Andrew Crouch
------------------------------

#InfoSphereOptim
#Optim