Router Scenario: Lets say  i have more then have record in source table  and i have 3 destination table A,B,C. I have to insert first 1 to 10 record in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 [...] […]

Problem: When using query override, error msg  is ”Invalid lookup override ”  and Below is the Query:  ”select a.accid, a.trans_date, a.trans_amt from acct_trans a, (select accid, max(trans_date) trans_date from acct_trans group by accid) b where a.accid=b.accid and a.trans_date=b.trans_date” Sol: This error may occurs when using sub-queries in a lookup SQL […]

Some validation rules: 1-You can only link ports with compatible datatypes. 2-You cannot connect an active transformation and a passive transformation to the same downstream transformation. 3-You cannot connect more than one active transformation to the same downstream transformation or transformation input group.only way to do it using joiner with sorted po […]

  Use the following formula to determine the size of incoming data: # input rows ([Sum(column size)] + 16) […]

Lets say you have 2 columns in source table. Do the following in an expression: A(in) B(in) A_Pre(V) = A B_Pre(V) = B Comp(V) = IIF( A= A_Pre and B= B_Pre, ‘Y’,'N’) Basically you need to store the previous values in a variable and compare with incoming data. […]

1. Informatica and Ab Initio both support parallelism. But Informatica supports only one type of parallelism but the Ab Initio supports three types of parallesims. In Informatica the developer need to do some partions in server manager by using that you can achieve parallelism concepts. But in Ab Initio the tool it self take care [...] […]

 Node : Node is the logical representation of a machine in a domain. The machine in which the PowerCenter is installed acts as a Domain and also as a primary node. We can add other machines as nodes in the domain and configure the nodes to run application services such as the Integration Service or Repository [...] […]

Domain Configuration: Domain Configuration Some of the configurations for a domain involves assigning host name, port numbers to the nodes, setting up Resilience Timeout values, providing connection information of metadata Database, SMTP details etc. All the Configuration information for a domain is stored in a set of relational database tables within the re […]

PowerCenter Domain A domain is the primary unit for management and administration of services in PowerCenter. Node, Service Manager and Application Services are components of a domain. […]

There should be some typo in the Parameter file. Please check the following: 1)The Folder name should be exactly the same where this workflow/Session is lying. 2)Check the authenticity of the Value that you are passing for the Parameter in the Parameter file. 3)The most important, please check the trailing spaces of the Value, Foldername,Workflow/Session nam […]

AsiaOneData integration going wide in Asia: InformaticaAsiaOneThis interest has been a boon to Informatica, which specialises in data integration technology. Furthermore, with momentum strong especially in Asia's ... […]

A Peek Into The Market Before The Trading StartsBenzingaOppenheimer & Co. is raising its price target on Informatica Corporation (NASDAQ: INFA) to $36 after meeting with management. In a note to clients, ...and more » […]

Watch for Continued Gains in Shares of Informatica (INFA)Comtex SmartrendShares of Informatica (NASDAQ:INFA) traded near a new 52-week high yesterday of $33.80. Approximately 800000 shares traded hands yesterday vs. ...and more » […]

Dolby and Positivo Deliver Premium Audio on Personal Computers in BrazilMarketWatch (press release)Positivo Informatica is the only Brazilian PC manufacturer to integrate Dolby audio technologies into its netbooks, notebooks and desktops. ...and more » […]

Informatica Launches Partner Implementation Accreditation ProgramMarketWatch (press release)Informatica Corporation , the world's number one independent provider of data integration software, today announced the Informatica Partner Implementation ...and more » […]

Global CIO: Larry Ellison's Acquisition List: Who's #1?InformationWeekInformatica and Teradata are the favorites of poll respondents, but my votes go to EMC and Netezza. By Bob Evans History tells us that Oracle's due to ...and more » […]

Informatica Looks to Continue to Trade Above its Annual-High Share Price Today ...BenzingaShares of Informatica (NASDAQ: INFA) traded at a new 52-week high today of $33.28. Approximately 201000 shares have traded hands today vs. average 30-day ...Informatica Corp. (INFA) CFO, EVP Finance and Administr Earl E Fry sells ...GuruFocus.comAsian Paints adopts Info […]

Asian Paints Primes Its Data With InformaticaMarketWatch (press release)Informatica Corporation (NASDAQ:INFA) , the world's number one independent provider of data integration software, today announced that Asian Paints, ...Informatica Corp. Climbed To Another New HighRTT NewsInformatica PowerCenter implemented by Asian PaintTMCnetINFORMATICA LOOKS TO C […]

Dana-Farber Cancer Institute Improves Cancer Research and Care With the ...MarketWatch (press release)-- Today Informatica Corporation , the world's number one independent provider of enterprise data integration software, announced that Dana-Farber Cancer ...and more » […]

Hachette Book Group Powers Enterprise Intelligence With Informatica PlatformMarketWatch (press release)Informatica Corporation , the world's number one independent leader in data integration software, today announced that Hachette Book Group (HBG), ...and more » […]