Informatica

This blog is the best online resource for informatica tutorial. It contains informatica queries and informatica new updates.

Monday, April 7, 2014

How to handle apostrophe in Informatica?


In informatica CHR(39) refers ' (apostrope).
Let we want to bring the output as "Tarun's  Blogs" then the variable expression must be defined as below

v_out= 'Tarun'||CHR(39)||'s Blogs' 
Posted by Unknown at 2:16 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: apostrophe or single quote in Informatica, How to handle apostrophe in Informatica, How to handle single quote in Informatica

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Total Pageviews

About Me

Unknown
View my complete profile

Blog Archive

  • ▼  2014 (10)
    • ▼  April (8)
      • How to seperate header and Footer from Flat File u...
      • Informatica Administrator Training
      • Best Practices when building Maps
      • How to handle apostrophe in Informatica?
      • Problems in Source Definition field with zero length
      • How to serach Informatica mappings from meta data ...
      • How to run a single session multiple times in a flow?
      • How to get ratio of two numbers through informatica?
    • ►  March (2)
Simple theme. Theme images by luoman. Powered by Blogger.