Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Convert into upper case

Convert into upper case

Convert into upper case

Hi Informatica Gurus,

I have source data in normal case. I want to load upper case into the target table.

I know only the below synarios. Dont know if there is any other way to improve the performance.

Flat File Source.
1. converting into upper case using the TR package.
2. Using expression in the mapping.

Database source.
1. Upper case in the source qualifier.
2. Upper function in the expression.

Is there any other way of converting it into upper which is better performance wise.


RE: Convert into upper case


Other than getting the Source System to create the field in Upper Case, the only performance considerations would be where in the process the data is converted.

And performance considerations for this would only be needed if you had a large volume of rows/records to process.
For example...
-  if data is filtered, do not convert the data until all filters have run.
-  If the field is moving to a smaller sized column, convert after the field after it has been sub-stringed
-  use a stored procedure - the UPPER command in the Database Engine is faster than the Informatica Transformation function.   

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close