Trending September 2023 # Source Analyzer In Informatica # Suggested October 2023 # Top 15 Popular | Nhunghuounewzealand.com

Trending September 2023 # Source Analyzer In Informatica # Suggested October 2023 # Top 15 Popular

You are reading the article Source Analyzer In Informatica updated in September 2023 on the website Nhunghuounewzealand.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 Source Analyzer In Informatica

In ETL/Data Warehouse, you will encounter different sources and targets.

Source Definition in Informatica

A Source Definition in Informatica is an entity from where you pull the records, and then you store these records in temporary tables (staging tables) or Informatica transformation caches. On the basis of mapping design document/business requirement you make a change in these data records (transform the data) and then you load the transformed data in another tables structures, called target tables.

In every Informatica mapping, there will always be a source and a target. To manage different sources and targets in Informatica, you have to use source analyzer and target designer. These tools are integrated into Powercenter designer tool and can be launched from there itself.

In this Tutorial – you will learn

Source Analyzer in Informatica

Source Analyzer in Informatica is a tool that allows you to create and modify source definitions. With the help of Source analyzer, you can create or import different types of sources in Informatica like flat files, relational databases, Excel worksheets, XML definitions, etc.

Similarly by using target designer, you can create or import different types of targets. Informatica provides you the feature to either create a source/target from scratch by designing its structure, or you can create a source/target by importing the definitions. When you Import Source from the Database, the following metadata gets imported:

Source (Table) name

Database location

Name of Columns

Columns Data types

Constraints

You can also define the key relationships in the tables, which is applicable only at Informatica level and is stored in the repository.

The source or target created/imported in Informatica can be reused any no of times in different mappings. Every mapping must have at least on loadable target. Otherwise mapping will be invalid.

Note– When we create source/target in source analyzer/target designer, structures are only created in Informatica. At the database level, there is no object created. So, you have to create Database objects having the same structure as you have created in Informatica.

You can import following type of sources using source analyzer

Relation tables ( database tables), views and synonyms

Flat files

Cobol files

XML files

Performance tip – To improve the performance of Relational Source tables, use indexes on the source database tables. On the target, tables disable or remove constraints and indexes for performance.

How to Open Source Analyzer in Informatica

Below is a step by step process for opening Source analyzer in Informatica:

Step 1) Open Informatica PowerCenter designer tool

Step 2) In next screen

Enter username

Enter Password

After Successful login, the folders of the user will be listed under the repository name

Note –

If login is not successful, check if the user has privileges of connecting to repository

If no folder is visible under repository name, check if the folder is created.

If a folder was created recently then disconnect from the repository and reconnect.

Step 3) In the next step

Select open option

When a folder is open, subfolders of that folder will be listed.

How to Import Source Table in Source Analyzer

Following are the steps to import source table in Informatica Source Analyzer:

Step 1) Go to “Sources” option

In source analyzer

Select import from database option, after this ODBC Connection box will open.

Step 2) Create ODBC connection

We will now create ODBC connection (If you already have ODBC connection, move to step 3)

    A DSN (Data Source Name) is basically a data structure, and it contains information about a specific details (database type, location, user details, etc.). This information is required by ODBC driver so that it can connect to that database.

      Note – Database details are specific to your installation depending on hostname, port and SID you selected during database installation. You can get this details by opening tnsnames.ora file located in your oracle installation folder.

        Once you made a Test Connect, enter database username, password and then select “OK” button

        If the connection is successful, it will show a message box.

          Select OK for test connect window and ODBC Driver setup window. The Created ODBC Data Source will be added to user data sources. Now we are set with ODBC Data source.

          Step 3) Create Schema tables

          In guru99, you will be using oracle’s Scott/Tiger schema tables. If you do not have these tables in the database, create those using this script

          Download the above chúng tôi File

          Step 4) Enter the Database details

          In the import tables window:

          Select ODBC data source for the oracle database.

          Enter database username

          Enter database password

          Expand the tree under tables folder and select EMP table

          Select OK button.

          Step 5) Verify and save the imported table

          The table will be imported in the Informatica Source Analyzer. Use “Ctrl+S” keys to save changes to the repository

          Similarly, you can import any other database tables in source analyzer.

          How to Import Target in Informatica Target Designer

          Here is a process to import target in Informatica Target Designer:

          In this tutorial, you will create target table emp_target, which will be having the identical structure of the source EMP table. To import target table, the target table must be present in the database. To create target table use the below script. Types of targets available in Informatica are relational, XML and flat files.

          Download the above emp_target.sql File

          Note – here in this tutorial, both source and target table are present in the same database schema (guru99). However, you can also create a target in a different schema.

          Step 2) In next step

          Select option “Targets” from the main menu

          Select “import” from database option

          Step 3) In the import table window.

          Select ODBC data source for the oracle database.

          Enter database username

          Enter database password

          Expand the tree under tables folder and select EMP_TARGET table

          Select OK button

          This will import target in Target Designer of Informatica Powercenter. Use “ctrl+s” key to save the changes.

          In this tutorial, you have imported sources and targets. Now, you are all set to create your first mapping.

          How to Create a Folder in Informatica

          Below are the steps on how to create a folder in Informatica:

          Informatica folders are logical containers, which keeps the objects that you create in Informatica designer/ Workflow manager (mappings, mapplets, sources, targets, etc.)

          To create a folder:

          Step 1) Open Repository Manager

          Note – If Informatica Designer is already open, then repository manager can be opened using the shortcuts available in the toolbox.

          This will open Informatica Repository Manger in a separate window.

          Step 2) Follow these steps

          Select Create option

          Step 3) In next step

          Enter Desired folder name

          Select ok

          This will create a new folder and a message will appear saying “The folder has been successfully created.”

          The newly created folder will be listed under the respective repository.

          This completes the tutorial. See you in the next one!

          You're reading Source Analyzer In Informatica

          Update the detailed information about Source Analyzer In Informatica on the Nhunghuounewzealand.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!