Hello INFORMATICANS! « Informaticans

Hello INFORMATICANS!

Welcome to the INFORMATICANS site. An ultimate site where all the Informatica and DataWarehousing related queries can be discussed and answered by the experienced Informatica developers and Data Warehousing experts.Lets have the FUN..!

This entry was posted on Wednesday, May 6th, 2009 and is filed under Uncategorized. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.

Comments (2)

#1 by Mr WordPress at May 6th, 2009

| Quote

Hi, this is a comment.
To delete a comment, just log in and view the post's comments. There you will have the option to edit or delete them.
#2 by Suman at January 2nd, 2010

| Quote

Really good blog on Informatica … has useful information … keep posting …

- Informatica
- Uncategorized
Informaticans
Router Scenario in Informatica
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 [...] […]
Invalid Lookup Sql Override issue in Informatica?
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 […]
Validation rules for Connecting transformations in Informatica?
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 […]
How to calculate the size of the input data in Informatica
Use the following formula to determine the size of incoming data: # input rows ([Sum(column size)] + 16) […]
How to remove Duplicates of records using Informatica?
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. […]
What are the differences between Informatica and Ab-Initio?
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 [...] […]
What is a Node in Informatica?
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 [...] […]
What is Domain Configuration in Informatica?
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 […]
What is a Domain in Informatica?
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. […]
TM_6270 Error: Variable parameter expansion error in Informatica
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 – Google News
Data integration going wide in Asia: Informatica - AsiaOne September 3, 2010
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 Starts - Benzinga September 3, 2010
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 Smartrend September 3, 2010
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 Brazil - MarketWatch (press release) September 1, 2010
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 Program - MarketWatch (press release) August 31, 2010
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? - InformationWeek August 30, 2010
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 ... - Benzinga August 25, 2010
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 Informatica - MarketWatch (press release) August 23, 2010
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) August 18, 2010
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 Platform - MarketWatch (press release) August 16, 2010
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 » […]

Informaticans

All about Informatica

Hello INFORMATICANS!

Comments (2)

Informaticans

Informatica – Google News