Scribd
Upload
110 views20 pages

Informatica Mini Project Overview

The document describes two mini Informatica projects. The first project imports an employee information source file, creates two target tables, maps the source to targets using expressions and a joiner, creates a session, and runs the workflow to generate two target files with previous and next month salary details. The second project imports an employee details source file, creates one target table, maps the source to target using an expression, creates a session, runs the workflow to generate a target file with employee details.

Uploaded by

s
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as KEY, PDF, TXT or read online on Scribd
110 views20 pages

Informatica Mini Project Overview

The document describes two mini Informatica projects. The first project imports an employee information source file, creates two target tables, maps the source to targets using expressions and a joiner, creates a session, and runs the workflow to generate two target files with previous and next month salary details. The second project imports an employee details source file, creates one target table, maps the source to target using an expression, creates a session, runs the workflow to generate a target file with employee details.

Uploaded by

s
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as KEY, PDF, TXT or read online on Scribd

INFORMATICA MINI

PROJECT
Zooper Problem
First Project
Creating source file:
Created source file named “src_Emp_Info” in srcFiles folder in the TXT format.
Imported source file in designer:
Imported the source file from files using “import from files” tab in sources tab.
Created two target tables:
Created two target files in flat file format using create option in target tab, one target
file is named as “tgt_emp_prev” and other one is named as “tgt_emp_next”.
Mapping Creation:
Created mapping of the mini project using three expression transformation and one joiner transformation.
Conditions used in mapping Transformation

For Previous salary condition: For next salary condition:


Creating session :
Created session in workflow manager and connected it with the workflow by using linker.
Running the Job:
After starting the task in workflow manager, workflow monitor get started and it’s showing
the status of the job as “succeeded” and also at the bottom we can see the “sources/Target Statistics”.
Target files:
We get two target files in the tgtFiles folder in the files section. The first target file called “tgt_emp_prev” is of previous month salary detail and the second file called
“tgt_emp_next” is of next month salary details.

Previous month salary detail target file: Next month salary detail target file:
HDCF Bank Problem
Second Project
Creating source file:
Created source file named “src_Emp_Details” in srcFiles folder in the TXT format.
Imported source file in designer:
Imported the source file from files using “import from files” tab in sources tab.
Created a target table:
Created one target table by using create option from target tab and named it as “tgt_emp_details”.
Mapping Creation:
Created mapping of the mini project using one expression transformation in between source and target definition.
Conditions used in mapping Transformation:
Creating session :
Created session in workflow manager and connected it with the workflow by using linker.
Running the Job:
After starting the task in workflow manager, workflow monitor get started and it’s showing
the status of the job as “succeeded” and also at the bottom we can see the “sources/Target Statistics”.
Target files:
After running the workflow the target file called “tgt_emp_detail” will be reflected in the tgtfiles folder in files section.
THANK YOU

You might also like