to follow, share, and participate in this community.
Not a member? Sign Up!
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... 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... 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... 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... 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... 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... 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... 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... 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... 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... 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... 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... 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 ... 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... 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... 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... 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... 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... 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... 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 ...