Sunday, December 5, 2010

Import Relational Source & Target Definitions

To import a relational source definition:

  1. In the Source Analyzer, click Sources > Import from Database.

  2. Select the ODBC data source used to connect to the source database.
  3. If you need to create or modify an ODBC data source, click the Browse button to open the ODBC Administrator. Create the data source, and click OK. Select the new ODBC data source.
  4. Enter a database user name and password to connect to the database.
  5. Note: The user name must have the appropriate database permissions to view the object.

    You may need to specify the owner name for database objects you want to use as sources.
  6. Click Connect.
  7. If no table names appear or if the table you want to import does not appear, click All.
  • Scroll down through the list of sources to find the source you want to import. Select the relational object or objects you want to import.
  • You can hold down the Shift key to select a block of sources within one folder, or hold down the Ctrl key to make non-consecutive selections within a folder. You can also select all tables within a folder by selecting the folder and clicking Select All. Use the Select None button to clear all highlighted selections.
  • Click OK.
  • The source definition appears in the Source Analyzer. In the Navigator, the new source definition appears in the Sources node of the active repository folder, under the source database name.
  • Click Repository > Save.
  • 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.

    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 to 60 in C……So on upto last record.

    Solution:

    Generate sequence number using informatica, add filter or router transformations and define the conditions accordingly…

    Define group condition as follows under router groups….

    Group1 = mod(seq_number,30) >= 1 and mod(seq_number,30) <= 10
    Group2 = mod(seq_number,30) >= 11 and mod(seq_number,30) <= 20
    Group3 = (mod(seq_number,30) >=21 and mod(seq_number,30) <= 29 ) or mod(seq_number,30) = 0

    Connect Group1 to A, Group2 to B and Group3 to C

    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 repository. Some of the global properties that are applicable for Application Services like ‘Maximum Restart Attempts’, ‘Dispatch Mode’ as ‘Round Robin’/’Metric Based’/’Adaptive’ etc are configured under Domain Configuration

    Informatica Power Center 8.6 Architecture and Installation Steps


    Pre-Requisites:Installtion need atleast 2GB temp space .

    Need 16K default page tablespace for domain creation.

    1)First Install domain and create domain tables.

    2)Now Define domain name and assign nodes

    3)In PowerCenter Administrator console you have to create repository service.

    4)Now Create repository (or upgrade repository)

    5)In the Power Center Administrator console you have to create Integration service.

    6)In the Powe rCenter Administrator console you have to create Metadata service.

    7)Also Create Data profiling warehouse table in Data Profiling schema.

    8)In PowerCenter Administrator console you have to create Reporting service.

    9)In reporting service you have to create data analyzer repository in Data Analyzer schema.

    To Start the Service

    ../server/tomcat/bin/infaservice.sh startup

    Installation Error-Informatica 8.6 in windows server 2008

    Hello All,
    Does Informatica 8.6 is compatible with windows server 2008 OS , i am getting the below error message when i am trying to install to it, can anyone help me out to resolve this, appreciate your time.

    Kindly provide me the list of powercenter editions and itz compatibity info against all Windows OS versions

    Error Message:
    cannot start Informatica Services. Use the error below and catalina.out and node.log in the server/tomcat/logs directory on the current machine to get more information. Select Retry to continue the installation.
    EXIT CODE: S

    Info:

    OS-Win Server 2008

    DB-ORCLE 10G XE

    INFA Edition- PC 8.6

    Netscape vs. Google

    If Netscape was the standard bearer for Web 1.0, Google is most certainly the standard bearer for Web 2.0, if only because their respective IPOs were defining events for each era. So let's start with a comparison of these two companies and their positioning.

    Netscape framed "the web as platform" in terms of the old software paradigm: their flagship product was the web browser, a desktop application, and their strategy was to use their dominance in the browser market to establish a market for high-priced server products. Control over standards for displaying content and applications in the browser would, in theory, give Netscape the kind of market power enjoyed by Microsoft in the PC market. Much like the "horseless carriage" framed the automobile as an extension of the familiar, Netscape promoted a "webtop" to replace the desktop, and planned to populate that webtop with information updates and applets pushed to the webtop by information providers who would purchase Netscape servers.

    In the end, both web browsers and web servers turned out to be commodities, and value moved "up the stack" to services delivered over the web platform.

    Google, by contrast, began its life as a native web application, never sold or packaged, but delivered as a service, with customers paying, directly or indirectly, for the use of that service. None of the trappings of the old software industry are present. No scheduled software releases, just continuous improvement. No licensing or sale, just usage. No porting to different platforms so that customers can run the software on their own equipment, just a massively scalable collection of commodity PCs running open source operating systems plus homegrown applications and utilities that no one outside the company ever gets to see.

    At bottom, Google requires a competency that Netscape never needed: database management. Google isn't just a collection of software tools, it's a specialized database. Without the data, the tools are useless; without the software, the data is unmanageable. Software licensing and control over APIs--the lever of power in the previous era--is irrelevant because the software never need be distributed but only performed, and also because without the ability to collect and manage the data, the software is of little use. In fact, the value of the software is proportional to the scale and dynamism of the data it helps to manage.

    Google's service is not a server--though it is delivered by a massive collection of internet servers--nor a browser--though it is experienced by the user within the browser. Nor does its flagship search service even host the content that it enables users to find. Much like a phone call, which happens not just on the phones at either end of the call, but on the network in between, Google happens in the space between browser and search engine and destination content server, as an enabler or middleman between the user and his or her online experience.

    While both Netscape and Google could be described as software companies, it's clear that Netscape belonged to the same software world as Lotus, Microsoft, Oracle, SAP, and other companies that got their start in the 1980's software revolution, while Google's fellows are other internet applications like eBay, Amazon, Napster, and yes, DoubleClick and Akamai.

    What Is Web 2.0

    Design Patterns and Business Models

    The bursting of the dot-com bubble in the fall of 2001 marked a turning point for the web. Many people concluded that the web was overhyped, when in fact bubbles and consequent shakeouts appear to be a common feature of all technological revolutions. Shakeouts typically mark the point at which an ascendant technology is ready to take its place at center stage. The pretenders are given the bum's rush, the real success stories show their strength, and there begins to be an understanding of what separates one from the other.

    The concept of "Web 2.0" began with a conference brainstorming session between O'Reilly and MediaLive International. Dale Dougherty, web pioneer and O'Reilly VP, noted that far from having "crashed", the web was more important than ever, with exciting new applications and sites popping up with surprising regularity. What's more, the companies that had survived the collapse seemed to have some things in common. Could it be that the dot-com collapse marked some kind of turning point for the web, such that a call to action such as "Web 2.0" might make sense? We agreed that it did, and so the Web 2.0 Conference was born.

    In the year and a half since, the term "Web 2.0" has clearly taken hold, with more than 9.5 million citations in Google. But there's still a huge amount of disagreement about just what Web 2.0 means, with some people decrying it as a meaningless marketing buzzword, and others accepting it as the new conventional wisdom.

    This article is an attempt to clarify just what we mean by Web 2.0.

    In our initial brainstorming, we formulated our sense of Web 2.0 by example:

    Web 1.0 Web 2.0
    DoubleClick --> Google AdSense
    Ofoto --> Flickr
    Akamai --> BitTorrent
    mp3.com --> Napster
    Britannica Online --> Wikipedia
    personal websites --> blogging
    evite --> upcoming.org and EVDB
    domain name speculation --> search engine optimization
    page views --> cost per click
    screen scraping --> web services
    publishing --> participation
    content management systems --> wikis
    directories (taxonomy) --> tagging ("folksonomy")
    stickiness --> syndication

    The list went on and on. But what was it that made us identify one application or approach as "Web 1.0" and another as "Web 2.0"? (The question is particularly urgent because the Web 2.0 meme has become so widespread that companies are now pasting it on as a marketing buzzword, with no real understanding of just what it means. The question is particularly difficult because many of those buzzword-addicted startups are definitely not Web 2.0, while some of the applications we identified as Web 2.0, like Napster and BitTorrent, are not even properly web applications!) We began trying to tease out the principles that are demonstrated in one way or another by the success stories of web 1.0 and by the most interesting of the new applications.

    Remove Virus From Virus Effected System

    Hai Friends

    Today i am going to give some information on how to remove the virus from a virus effected system without removing data or operating system.

    Please download the tool from the following link and
    just restart ur system in Safemode and run the tool

    Hope ur enjoy the work.