• Enhancement to RPAD or LPAD function

    score55
    Active
    11 votes
    Dear Infa Technical team, I have observed one limitation to LPAD/RPAD (Might be developed in that way only not sure). Presently LPAD/RPAD doesnot accept second orgument as dynamic value,when we use a dynamic value i...
    user164469
    created by user164469
  • When we change the name of Variable it should replicate in mapping

    score35
    Active
    7 votes
    Dear Infa Team,   I have a suggestion ..when ever we create any variable port and uses in any expression , the name will change automatically when we change the name of variable port.   But incase of varia...
    user164469
    last modified by user164469
  • Rank Transformation doesn't function as SQL Rank Function

    score30
    Active
    8 votes
    Hi,   I had a query regarding the Rank transformation. For me, the Rank transformation should behave no different than the rank function in SQL.   Lately, working on a particular logic, I discovered that t...
    nelrick
    last modified by nelrick
  • moving selected ports to top most or bottom most in transformation

    score30
    Active
    6 votes
    Dear Informatica team,   I have a suggestion.   In any transformation, when we have huge number of ports and if it is needed to move a specific port to top most or bottom most, we need to click on up arrow o...
  • Automate historic data migration between two dates

    score25
    Active
    5 votes
    1. Introduction 1.1. Limitation of most of the job schedulers. Most of the ETL job schedulers have no option to execute/schedule ETL jobs in a controlled fashion to load historic data between two dates. This is a us...
    user161619
    last modified by user161619
  • Disable (and restore!) ports in Lookup transformation

    score25
    Active
    5 votes
    Option to automatically remove unused ports in a mapping (or  even across several mappings). This is known to speed up a mapping, but  is easily forgotten during design. Lookup boxes should have a  way...
    EC63730
    created by EC63730
  • UUID PowerCenter Function

    score25
    Active
    5 votes
    Add a PowerCenter function that returns a universally unique identifier (UUID).  Possible allowing the developer to select the version (MAC, DCE Security, MD5 Hash, Random, SHA-1 Hash)  A format feature is i...
    user130649
    created by user130649
  • Option to skip trailor record

    score25
    Active
    5 votes
    Dear Infa Technical team,   I have a thought in mind, dont know how far feasible to implement in the application.   Presently we have an option of skip rows in source by using that we can skip header or ma...
    user164469
    last modified by user164469
  • Create ilmcmd command to assign rule, create plan and group of tables in TDM

    score25
    Active
    5 votes
    Hello, Would it be possible to have new features from the ilmcmd command line, in order to   - assign rule to column in Test Data Management (TDM) - create a plan - create a group of tables ?    K...
    David00u18y309i0i07FeS1d8
    last modified by David00u18y309i0i07FeS1d8
  • Column names expanding and scroll bar moving diabled in Source preview window

    score20
    Active
    4 votes
    Dear Infa technical team,   While previewing the Source data i observed column names expansion and scroll bar movement is diabled...If at all we want to see how many columns and any particular column name to obs...
    user164469
    created by user164469
  • How to Get the TGTSuccess Rows if we have three Different Target Table

    score15
    Active
    3 votes
    Hi All,   I have a requirement like this I have three different Target Table in one mapping in the same pipeline Table No 1 = A Table No 2 = B Table No 3 = C     I want to take the TGTSuccessRows...
    Salman_Khan
    created by Salman_Khan
  • Informatica Power Center session Log

    score15
    Active
    3 votes
    Large Organization like HP, WallMart, Morgan Stanley, Apple use Informatica power center for their Data Integration, for that, they have created a lot of mappings and sessions.   Now when the Performance is ba...
  • Better view of expression code in debugging mode

    score15
    Active
    3 votes
    Dear Infa Team,   When ever we are in debugging mode, codes are which are one liner we can easily in filter and aggregator etc. But at times the code will be long and it is tough to see in a single line view.It ...
    user164469
    last modified by user164469
  • Limit the amount of physical resources being used by specific mappings or workflows

    score15
    Active
    3 votes
    I would like to have the ability to limit or constrain how much of my physical machine resources are being taken up by specific mappings or workflows.  If I have a large hardware environment, I want to for exampl...
    user179865
    created by user179865
  • Option to edit session task to correct the Mapping attached

    score15
    Active
    3 votes
    Dear Infa team,   I guess this will be a great idea to provide the option to edit the session task to link to the proper Mapping. Currently if by mistake we attach the session with the wrong mapping and check in...
    EC52595
    created by EC52595
  • Create ilmcmd command to import metadata in TDM project from a Powercenter Repository

    score10
    Active
    2 votes
    Hello,   Would it be possible to create a new ilmcmd command line in order to import metadata in TDM project from a Powercenter Repository ?   Currently it is only possible to do it manually with TDM workb...
    David00u18y309i0i07FeS1d8
    last modified by David00u18y309i0i07FeS1d8
  • New function to insert a transformation in mapping

    score10
    Active
    4 votes
    I have many times wished for a function to "insert a transformation after another transformation". For example, insert a Filter immediately after a Source Qualifier. The logic would be that all outgoing links from t...
    EC63730
    created by EC63730
  • choosing appropriate connection name -- can be Informatica user friendly option

    score10
    Active
    2 votes
    Hi Infa Team,   While selecting connection names at workflowmanager -> connections -> (any type relational, applciation etc) , if suppose i have connection names as ora_dev, rose_dev,app_prod.   If I...
    EC74383
    created by EC74383
  • Importing Oracle Source table with columns having TIMESTAMP datatype

    score10
    Active
    2 votes
    Hi Infa Team, I observed one scenario while importing the Source table structure, so thought of writing it here as this could be useful for others too. When I tried importing tables from Oracle Database,even though t...
    EC52595
    last modified by EC52595
  • Transformation to Implement loop logic

    score10
    Active
    6 votes
    Implementation of loop logic is only possible with Java transformation or calling Stored Procedure which effects performance. Instead why not have a transformation which can handle a loop logic, where the requirement ...
    EC78941
    created by EC78941