Informatica Scenarios

SCENARIO 1: TAKE THE BACKUP OF THE TABLE USING SOURCE QUALIFIER TRANSFORMATION

 Source Table: EMP Table

 Target Table: Emp_Bkp

 CREATE TABLE EMP_BKP AS SELECT * FROM EMP WHERE 1=2;

 Check: SELECT COUN FROM EMP_BKP;

 Soln:

Ø    In Source Analyzer, import the EMP table

Ø  Create a Table similar to Emp Table structure in database.

Ø  Now in target designer import emp_bkp table.

Ø  In mapping designer, create a new mapping drag and drop the source , target table structure and Map it.

Ø   Save it.

Ø   Now goto the Workflow manager, create a Flow and Task.

Ø   Assign mapping to the task session.

Ø  Now double click on task and check source table and in Target under mapping of Tasks, Select ‘Target Load Type’ to ‘normal’ and Click Ok.

Ø   Again Save It.   

Ø Now right click on task and Select ‘Start Work Flow from Task’ and Monitor the task in Workflow monitor.

SCENARIO: 2 – SPLITTING NON KEY COLUMN TO SEPARATE TABLE WITH KEY COLUMN IN BOTH.

Source Table: SRC_2

Target Table: TGT_2A, TGT_2B

  

   

  

  

   Ø  Drag and Drop the source and target tables in Mapping designer

   Ø  In Mapping designer, to the Source Qualifier connect an aggregator with key column to be           grouped.
   -Ø  Now to split Non key column add 2 Expression Tf with Key Column each.

   -Ø  To the Expression transformation add set of Aggregator transformation and group by the Key       Column.

   -Ø  In the final step connect Aggregators to target tables.