Sunday, 10 November 2013

Informatica Session: Sources and Targets Properties and Connection


Source Connection
Define source data connection for each source qualifiers. If the base tables for source qualifiers are from different databases then we should define any of the databases as connection database for all source qualifiers. We need to grant SELECT privilege on all the tables from different databases to the Connection Database. This task is done at Database level.

Target Connection
Select Relational Writer if the target is a Table else select File Writer if the target is a Text  File i.e. Flat File .If File Writer is selected then use 'Set file properties' button to define file structure like: Delimiter, Text Qualifier, etc and to give extra character instead of nulls in flat files.

Properties Page
If Relational Writer is selected then set the following properties:
  • Target load type: Normal or Bulk
  • Insert, if this option is Unchecked then target table can not receive New Records.
  • Delete, if this option is Unchecked then target table does not allow deletion of records.
“Update as Update or Update as Insert or Update else Insert”
Any one of them can be checked.
  • In first case records from source table with Update flag are searched into Target table, if found, they are updated else rejected (Update as Update).
  • In second case records from source with Update flag are inserted into target table (Update as Insert).
  • In third case records from source table with Update flag are searched into Target table, if found, they are updated they are Inserted (Update else Insert).
     
Truncate target table, if this option is checked then all the records from target table is deleted before data loading.
   
Reject file name and Folder path
If some of the records are rejected during the data loading process because of Data Type or Size mismatch then such records are written to a file referred as 'Bad File'. We need to define a name for such file and folder path using $PMBadFileDir variable or we have to give the complete folder path.

Connections Page:
Define Target database connection for each target table.

Source Filter:
For Source Qualifier Transformation we can use this property to define Filter condition to   retrieve selected records instead of all records. Using this property we can define parallel Data Loading even on single Source Table.

1 comment:

  1. this is a informative article.... including some scenarios on using them would be a great addition.. thanks

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis