• Option to attach file in Email task (Already there in email task at session level)

    score10
    Active
    4 votes
    Informatica team,   It would be nice to have option to attach any file in email task in workflow.   It is already availaible in email task as post session/success or failure through %a.   Regards Lalit
    EC41150
    last modified by EC41150
  • Importing Oracle Table Source with Number Data Type

    score5
    Active
    1 vote
    Hi Infa Team,   While importing Oracle Source table structure I have come across one scenario for the data type NUMBER which I want to bring to your notice. Even if Informatica has Source data type as NUMBER ...
    EC52595
    created by EC52595
  • A solution to fix TM_6707 ERROR

    score5
    Active
    1 vote
    Hello.   In this short tip I would like to present a solution for the occuring error in Informatica PowerCenter 9.1.0.   Error description is as follows: "TM_6707 ERROR: unable to acquire execute lock on s...
    rbtinf@gmail.com
    last modified by rbtinf@gmail.com
  • Create ilmcmd command to import metadata in TDM project from a Datasource Connection

    score5
    Active
    1 vote
    Hello,   Would it be possible to create a new ilmcmd command line in order to import metadata in TDM project from a Datasource connection available in TDM workbench (Administrator > Connections) ?   Cu...
    David00u18y309i0i07FeS1d8
    last modified by David00u18y309i0i07FeS1d8
  • Create pmrep to import metadata sources from a database (ODBC data source)

    score5
    Active
    1 vote
    Hello,   Would it be possible to create new pmrep command in order to import metadata sources from a database (ODBC data source) in PowerCenter ? Currently, it is only possible to do it manually in PowerCenter ...
    David00u18y309i0i07FeS1d8
    last modified by David00u18y309i0i07FeS1d8
  • More Control on Status of WF

    score5
    Active
    1 vote
    One of the common scenarios is stopping a WF when the session runs too long. There is a solution in MarketPlace but the problem is with the status of the WF which is "stopped", because it stops the Timer task, even th...
    PdtUser1833
    last modified by PdtUser1833
  • Email Domain

    score5
    Active
    1 vote
    Please provide your ideas in seperating email address and domain using informatica .   I have column which has email id and i want to seperate the domain from that and load to different column .I tried using RE...
    EC143701
    last modified by EC143701
  • Suggestion to include shortcuts for faster deployment

    score5
    Active
    1 vote
    Hi Team,     Suggestions to be included: UNDO ( Control + Z ) and REDO ( Control + Y ) shortcuts. Already existing shortcuts: Save ( Control + S ) , Copy ( Control + C ) and Paste ( Control + V ).   &...
    Natarajan Palani
    last modified by Natarajan Palani
  • Parameterization of Router transformation

    score0
    Active
    2 votes
    Hi,   I have created a document on, How to parametrize a Router transformation and Usage of Is Expression Variable.   Thanks & Regards, Kaja Chaitanya
    EC145102
    last modified by EC145102
  • Powercenter Mapping to establish Master Detail Relationship with simple Mapping Variable

    score0
    Active
    0 votes
    Use Case: Dataset indicating header and detail records are provided Header Rows and Detail Rows are ordered so that every header row is followed by its corresponding set of detail rows Besides the order of the ro...
    anitham@slalom.com
    last modified by anitham@slalom.com
  • informatica scenarios in video format

    score0
    Active
    0 votes
    Go throw this link u will find some scenarios with soluations in video format http://theonlinetutorials.blogspot.in/2014/08/informatica-scenarios.html
    EC114509
    created by EC114509
  • Problem

    score0
    Active
    0 votes
    Can we hide the source qualifier in the Monitor window? Can anyone give me a suggestion ?
    EC136755
    created by EC136755
  • How to sequence the sessions with flat load in a better way ?

    score0
    Active
    0 votes
    Hi All,   This is a simple method to sequence the sessions in a workflow which is of flat loading (Without any transformation or all sessions having same transformations).   Input: The table name and avera...
    EC84022
    last modified by EC84022
  • Extract the metadata extensions data from your repository

    score0
    Active
    0 votes
    We are constantly using metadata extensions and need the data in our datamodel. It would be handy to have powercenters standard mappings instead of below SQL.   On Mapping level we use: SELECT  METADATA_EX...
    user185092
    last modified by user185092
  • Allowing braces in the Lookup Source Filter

    score0
    Active
    0 votes
    Hello,   As in the Source Qualifier's (SQ) User Defined Join attribute it would be a nice feature to allow braces (i.e. { }) in the Lookup's Source Filter.   We use overrides to reduce the cache size. The ...
    ken.lacroix
    created by ken.lacroix
  • Using FitNesse as Specification By Example for PowerCenter

    score0
    Active
    2 votes
    Our testers use FitNesse (fitnesse.org) to describe their test cases. These include PowerCenter workflows. For this purpose we've created a FitNesse Fixture in Java that accesses the PowerCenter Web Service Hub to ru...
    jac@consag.nl
    created by jac@consag.nl
  • Informatica scheduling tool

    score0
    Active
    0 votes
       It would be better that informatica will have a scheduling & control tool. This can have similar properties like control-m.
    EC94387
    last modified by EC94387
  • How to generate dynamic target files

    score0
    Active
    0 votes
    I am trying to value date info to target file name.   command as below:   cat - > $PMTargetFileDir/date +"%Y%m".text     But it doesn't work in INFA9.5       Any advise ? ...
    konghao
    created by konghao
  • Integration service doesn't respond

    score0
    Active
    0 votes
    Hi All,   I met an issue regarding Integration service. I can edit mapping and workflow but I can not run workflow or connect Integration service. There is an error message "Integration service doesn't respond" ...
    EC77602
    created by EC77602
  • Ability to generate PowerCenter mapping from Teradata BTEQ scripts

    score0
    Active
    0 votes
    I would like to have an ability in PowerCenter to automatically generate mappings from Teradata BTEQ scripts. We like to move some of the functionality from Teradata to PowerCenter for better metadata management and ...
    user179865
    created by user179865