Informaticans

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 […]

Informatica Launches 18-City Customer Centricity Roadshow Across North AmericaMarketWatch (press release)Attendees at the Informatica Customer Centricity seminar will have the opportunity to hear more about the data challenges faced by many enterprises and how ...HealthNow New York Delivers New Data for Data Warehousing and SOA in Days With ...MarketWatch (p […]

Recent 52-Week High Exceeded in Shares of Informatica (INFA)Comtex SmartrendShares of Informatica (NASDAQ:INFA) traded at a new 52-week high today of $34.85. Approximately 152000 shares have traded hands today vs. ...RECENT 52-WEEK HIGH EXCEEDED IN SHARES OF INFORMATICA (INFA)Zacks.comall 3 news articles » […]

Dolby and Positivo Partner to Provide Audio Solutions on Personal Computers in ...Trading Markets (press release)Dolby Laboratories recently announced that one of Brazil's largest personal computer manufacturer, Positivo Informatica, features Dolby audio technologies ...and more » […]

Integration Expertise is a Career Booster - Just Ask Mark HurdIT Business Edge (blog)By date: Informatica's John Schmidt makes a strong argument for integration as a focal point of IT in the coming decade. Pulling quotes from a recent ...and more » […]

Informatica Enables Business Continuity for Teradata CustomersInvestor's Business DailyInvestor's Business Daily, IBD and CAN SLIM and their corresponding logos are registered trademarks of Data Analysis Inc. […]

Informatica Enables Business Continuity for Teradata CustomersMarketWatch (press release)By leveraging Informatica, Teradata users can now be shielded from the effects of such planned and unplanned outages since data will be loaded into multiple ...and more » […]

Informatica Moves Into New Trading Range Above $33.80 (INFA)Comtex SmartrendInformatica (NASDAQ:INFA) traded in a range yesterday that spanned from a low of $33.90 to a high of $34.72. Yesterday's high of the day ...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 » […]

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 […]

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 » […]