• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Importing and Exporting Objects in Informatica

Importing and Exporting Objects

Exporting repository objects

The repository objects such as mapping, session, workflows etc can be taken backup into .xml file format.

Procedure

From repository navigator window expand mapping subfolder select the mapping , from repository menu click on export objects select the path to save an xml file. Click on save

Importing repository objects

Create a new folder, open the client designer activate the folder [right click , click on open]

From repository menu click import object

Click on browser select and xml file select the xml file click ok

Click on next click import , click finish

Difference between normal load and Bulk load

Normal Loading

The session which is configured for normal load allows you to pass the data into the target viva “databse Log”  (redolog)

Since the records are enter into the database log,  the integration service can perform rollback on transaction errors.

As the result the integration service can perform session recovery.

Since the records are passing to the target viva database log the integration service “increases the data loading time”

Desired to gain proficiency on Informatica? Explore the blog post on Informatica training to become a pro in Informatica.

Bulk Loading

The session which is configured for bulk loading loads the high volumes of data into the target and increases session performances. When you configure the session with the bulkloading the integration service bypass the database log and enters the records into the target.

Since the integration service bypass the database log it can’t perform rollback on transaction error.

As a result the integration service can’t perform the session recovery.

The integration service does not support bulk loading into index target table.

Importing and Exporting Objects in Informatica

It loads record degrades

Importing and Exporting Objects in Informatica

  • Load records increase because the record loaded directly target. 

Design a maping which performs bulk wading into the target

Note

Don’t create primary key in the target databse but however you can primary in the target designer.

Procedure

Source defination tmp

target definition with the name tmp-BULK [from target menu select generate and execute primary and foriegn key]

Create a mapping with the name m-Bulk-Load

Drop the source and target defination

From SQL connect the ports to target

Create the session with the name, double click the session

Select the mapping tab set the reader and writer connection with target Load type “BULK”

Click Apply, click ok

Repository menu click on save

For indepth understanding of Informatica, click on

Summary
Review Date
Reviewed Item
Importing and Exporting Objects in Informatica
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

1 Responses on Importing and Exporting Objects in Informatica"

  1. Dhiraj says:

    As in INFORMATICA you may often have the need to obtain following things.
    1.List of users and associated groups
    2.Workflows that have last run
    3.Mappings in a folder
    4.Default values within a mapping

    This information can be queried in the PowerCenter tools

    Follow the Steps Given in Video – https://youtu.be/zbkPxiqD4GM
    and learn how to fire query on Repository.

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.