Advertisements
Home > Informatica > Informatica – The first character in a name cannot be a number (error)

Informatica – The first character in a name cannot be a number (error)


Today while creating a mapping by using import method & template I got a pop-up with following error message in Designer:

03/30/2016 16:30:55 **** Importing Source Definition: tblCustomerResults ...
     : The first character in a name cannot be a number.
** Failed to Import: tblCustomerResults

03/30/2016 16:30:55 **** Importing Target Definition: tblCustomerResults ...
     : A column with the name 120_-_Unknown already exists.  
       Please enter a unique name.
** Failed to Import: tblCustomerResults

03/30/2016 16:30:56 **** Importing Mapping: mACQtblCustomerResults ...
     : Could not find Transformation definition for: tblCustomerResults
** Failed to Import: mACQtblCustomerResults 

 

With the above error its quiet evident that Informatica do not support column names that starts with a number. But to confirm I checked online and found it to be true and one of the biggest limitation in Informatica.
 

As a workaround:

1. I dropped the Source Connection pointing to the Original source.

2. I created the Source table in my Database and re-created the Source Connection pointing to this table.

3. Save and export the Source XML.

4. Finally Import the mapping by using same template and the new Source XML, successful 🙂
 

I also found that this limitation is not only with columns, but also with Source Table Name, Database Definition (DBD) name, Repository Folders, etc.
 


Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: