Results 1 to 3 of 3
Like Tree2Likes
  • 2 Post By vijay

Thread: Informatica problem - insert characters in the middle of the string

  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    1

    Informatica problem - insert characters in the middle of the string

    hai
    vijay
    i have source look like as
    product_id,product_name
    111,abc
    222,xyz
    333,pqr

    i want to load this data into tgt like

    product_id,product_name
    1,a*b*c
    2,x*y*z
    3,p*q*r

    who to salve this please tell me DFD

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    512
    Ramesh,

    Do not post in the existing thread as it is unrelated to that one. Instead of hijacking, start new thread and ask your questions.

  3. #3
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    512
    You can write the below sql override query in the source qualifier transformation:

    Code:
    select substr(product_id,1,1), rtrim(regexp_replace(product_name,'(.)','\1*'),'*') from products;
    Doug11 and ramesh like this.

Similar Threads

  1. How to replace special characters in informatica
    By amrutha in forum Data Warehouse
    Replies: 1
    Last Post: 12-10-2012, 06:45 AM
  2. C program to etact M characters from the string
    By sarvani in forum C, CPP Programs
    Replies: 0
    Last Post: 10-15-2012, 09:32 AM
  3. Replies: 3
    Last Post: 09-12-2012, 06:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •