#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    2
    Rep Power
    0

    How to convert string into number using expression transformation in informatica?


    How to convert string into number using expression transformation in informatica?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    3
    Rep Power
    0

    How to convert multiple rows into single row in iformatica for large volume of data,


    I have data in table A as below
    Assetid attribute value
    1546 Ins_date 05062011
    1546 status active
    1546 X 10.4567
    1546 Y 27.56
    1546 size 17
    675 X 4.778
    675 Y 53.676
    675 depth 5
    675 st_date 06092010
    I have data as above in table A. This table has many Assetids 1546,675,....etc. attributes might vary for assets.
    I want output as below:
    assetid ins_date status X Y Size depth st_date
    1546 05062011 active 10.4567 27.56 17 null null
    675 null null 4.778 53.676 null 5 06092010
    I have created Stored procedure, then called in Informatica to achieve this output. However, since i have large volume of data, it is taking much time to load.
    Please suggest me other easy and best way to load it.

IMN logo majestic logo threadwatch logo seochat tools logo