Ho me

Inf o rmat ica

D at a Ware Ho using

Unix- She ll Scrip t s

PL SQ L

C o nt act Us

Complete reference to Informatica

17
Sharing

Ap r 20 11

WORKING WITH TASKS Part 1

Naveen

0
Discussion Forum

Transf ormat ion

Share

Filter

Discussio n Fo rum

Expressio n
Ro uter

Int roduct ion

ETL Life Cycle

The Wo rkflo w Manager co ntains many types o f tasks to help yo u build wo rkflo ws
and wo rklets. We can create reusable tasks in the Task Develo per.

So urce Qualifier
Task Type

Co nso le

To o l whe re t ask can Re usable o r no t

be cre at e d

Services Behind Scene

Try U R Hand's o n Admin-

Rank
Transactio n Co ntro l

Type s o f t asks:

What Is Info rmatica

Client Co mpo nents

So rter

Sessio n

Task Develo per

Sto red Pro cedure

SQL Transfo rmatio n

Yes

No rmalizer
Sequence Generato r
PDFmyURL.com

Difference Between 7.1 and

Email

Wo rkflo w Designer

Yes

Co mmand

Wo rklet Designer

Yes

Event-Raise

Wo rkflo w Designer

No

8 .6
Info rmatica 8 .6 Installatio n

Int erview Zone

Info rmatica Real Time
Interview Questio ns
Info rmatica Experienced

Unio n
Jo iner
Update Strategy
Lo o k Up

Event-Wait

Wo rklet Designer

No

Timer

No

Decisio n

No

Assignment

No

Co ntro l

No

Interview Questio ns - part1

Info rmatica Experienced

Aggregato r

Subscribe t o Learn
Inf ormat ica
Like

157 people like this.

Interview Questio ns - part2

Info rmatica Experienced
Interview Questio ns - part3
Info rmatica Experienced
Interview Questio ns - part4
Data Wareho using co ncept
Based Interview Questio ns

SESSION TASK
A sessio n is a set o f instructio ns that tells the Po wer Center Server ho w

Enter yo ur email address:

and when to mo ve data fro m so urces to targets.

To run a sessio n, we must first create a wo rkflo w to co ntain the Sessio n

Test ing
Unit Testing
Integratio n Testing
UAT
Info rmatica Testing
Debugger
Co nstraint Based lo ading
Target Lo ad Plan

task.
Sessio n tasks sequentially o r co ncurrently, depending o n o ur needs.

Mapping Parameter's &

depending o n the transfo rmatio ns and o ptio ns used in the sessio n.

EMAIL TASK
The Wo rkflo w Manager pro vides an Email task that allo ws us to send email
Created by Administrato r usually and we just drag and use it in o ur
mapping.
St e ps:

Variable

1. In the Task Develo per o r Wo rkflo w Designer, cho o se Tasks-Create.

Mapplets

2. Select an Email task and enter a name fo r the task. Click Create.

Partitio ning

Delivered by FeedBurner

The Po wer Center Server creates several files and in-memo ry caches

during a wo rkflo w.

Advanced
Concept s

Subscribe

We can run as many sessio ns in a wo rkflo w as we need. We can run the

Perf ormanceTuning
Necessity Of
Perfo rmance-tuning
Identificatio n Of bo ttle
Necks
Optimizatio n o f Bo ttle
necks
Perfo rmance tuning o f
Lo o kup
PDFmyURL.com

Partitio ning

3. Click Do ne.

Wo rking with links

4. Do uble-click the Email task in the wo rkspace. The Edit Tasks dialo g bo x

Scheduler

5. Click the Pro perties tab.

Types o f Task's- 2

6 . Enter the fully qualified email address o f the mail recipient in the Email User

SCD - Type 1
SCD - Type 2
SCD - Type 3

Name field.
7. Enter the subject o f the email in the Email Subject field. Or, yo u can leave

Grid Pro cessing

Chat wit h Me
Chat wit h Me
Offline

this field blank.

8 . Click the Open butto n in the Email Text field to o pen the Email Edito r.
9 . Click OK twice to save yo ur changes.

Incremental Aggregatio n
Mapping Templates

Push Do wn Optimizatio n

appears.

Types o f Task's- 1
Indirect Metho d fo r Lo ading

Lo o kup

Visit or's

Exam ple : To send an email when a sessio n co mpletes:

St e ps:

Wo rk Flo w Variables
1. Create a wo rkflo w wf_sample_email
2. Drag any sessio n task to wo rkspace.
3. Edit Sessio n task and go to Co mpo nents tab.
4. See On Success Email Optio n there and co nfigure it.
5. In Type select reusable o r No n-reusable.
6 . In Value, select the email task to be used.
7. Click Apply -> Ok.
8 . Validate wo rkflo w and Repo sito ry -> Save
We can also drag the email task and use as per need.
We can set the o ptio n to send email o n success o r failure in co mpo nents
tab o f a sessio n task.
COMMAND TASK
The Co mmand task allo ws us to specify o ne o r mo re shell co mmands in UNIX o r
DOS co mmands in Windo ws to run during the wo rkflo w.
Fo r example, we can specify shell co mmands in the Co mmand task to delete
reject files, co py a file, o r archive target files.
Ways o f using co mmand task:
1. St andalo ne Co m m and t ask: We can use a Co mmand task anywhere in the
wo rkflo w o r wo rklet to run shell co mmands.
PDFmyURL.com

2. Pre - and po st -se ssio n she ll co m m and: We can call a Co mmand task as
the pre- o r po st-sessio n shell co mmand fo r a Sessio n task. This is do ne in
COMPONENTS TAB o f a sessio n. We can run it in Pre-Sessio n Co mmand o r
Po st Sessio n Success Co mmand o r Po st Sessio n Failure Co mmand. Select the
Value and Type o ptio n as we did in Email task.
Exam ple : to co py a file sample.txt fro m D drive to E.
Co m m and: COPY D:\sample.txt E:\ in windo ws
St e ps f o r cre at ing co m m and t ask:
1. In the Task Develo per o r Wo rkflo w Designer, cho o se Tasks-Create.
2. Select Co mmand Task fo r the task type.
3. Enter a name fo r the Co mmand task. Click Create. Then click do ne.
4. Do uble-click the Co mmand task. Go to co mmands tab.
5. In the Co mmands tab, click the Add butto n to add a co mmand.
6 . In the Name field, enter a name fo r the new co mmand.
7. In the Co mmand field, click the Edit butto n to o pen the Co mmand Edito r.
8 . Enter o nly o ne co mmand in the Co mmand Edito r.
9 . Click OK to clo se the Co mmand Edito r.
10 . Repeat steps 5-9 to add mo re co mmands in the task.
11. Click OK.
St e ps t o cre at e t he wo rkf lo w using co m m and t ask:
1. Create a task using the abo ve steps to co py a file in Task Develo per.
2. Open Wo rkflo w Designer. Wo rkflo w -> Create -> Give name and click o k.
3. Start is displayed. Drag sessio n say s_m_Filter_example and co mmand
task.
4. Link Start to Sessio n task and Sessio n to Co mmand Task.
5. Do uble click link between Sessio n and Co mmand and give co nditio n in
edito r as
6 . $S_M_FILTER_EXAMPLE.Status=SUCCEEDED
7. Wo rkflo w-> Validate
8 . Repo sito ry > Save

PDFmyURL.com

WORKING WIT H EVENT TASKS

We can define events in the wo rkflo w to specify the sequence o f task executio n.
Type s o f Eve nt s:
Pre -de f ine d e ve nt : A pre-defined event is a file-watch event. This event
Waits fo r a specified file to arrive at a given lo catio n.
Use r-de f ine d e ve nt : A user-defined event is a sequence o f tasks in the
Wo rkflo w. We create events and then raise them as per need.
St e ps f o r cre at ing Use r De f ine d Eve nt :
1. Open any wo rkflo w where we want to create an event.
2. Click Wo rkflo w-> Edit -> Events tab.
3. Click to Add butto n to add events and give the names as per need.
4. Click Apply -> Ok. Validate the wo rkflo w and Save it.
Type s o f Eve nt s Tasks:
EVENT RAISE: Event-Raise task represents a user-defined event. We use
this task to raise a user defined event.
EVENT WAIT: Event-Wait task waits fo r a file watcher event o r user
defined event to o ccur befo re executing the next sessio n in the wo rkflo w.
Exam ple 1: Use an event wait task and make sure that sessio n s_filter_example
runs when abc.txt file is present in D:\FILES fo lder.
PDFmyURL.com

St e ps f o r cre at ing wo rkf lo w:

1. Wo rkflo w -> Create -> Give name wf_event_wait_file_watch -> Click o k.
2. Task -> Create -> Select Event Wait. Give name. Click create and do ne.
3. Link Start to Event Wait task.
4. Drag s_filter_example to wo rkspace and link it to event wait task.
5. Right click o n event wait task and click EDIT -> EVENTS tab.
6 . Select Pre Defined o ptio n there. In the blank space, give directo ry and
filename to watch. Example: D:\FILES\abc.tct
7. Wo rkflo w validate and Repo sito ry Save.

Exam ple 2: Raise a user defined event when sessio n s_m_filter_example

succeeds.

Capture

this

event

in

event

wait

task

and

run

sessio n

S_M_TOTAL_SAL_EXAMPLE
St e ps f o r cre at ing wo rkf lo w:
1. Wo rkflo w -> Create -> Give name wf_event_wait_event_raise -> Click o k.
2. Wo rkflo w -> Edit -> Events Tab and add events EVENT1 there.
PDFmyURL.com

3. Drag s_m_filter_example and link it to START task.

4. Click Tasks -> Create -> Select EVENT RAISE fro m list. Give name
5. ER_Example.

Click

Create

and

then

do ne.Link

ER_Example

to

s_m_filter_example.
6 . Right click ER_Example -> EDIT -> Pro perties Tab -> Open Value fo r User
Defined Event and Select EVENT1 fro m the list displayed. Apply -> OK.
7. Click link between ER_Example and s_m_filter_example and give the
co nditio n $S_M_FILTER_EXAMPLE.Status=SUCCEEDED
8 . Click Tasks -> Create -> Select EVENT WAIT fro m list. Give name
EW_WAIT. Click Create and then do ne.
9 . Link EW_WAIT to START task.
10 . Right click EW_WAIT -> EDIT-> EVENTS tab.
11. Select User Defined there. Select the Event1 by clicking Bro wse Events
butto n.
12. Apply -> OK.
13. Drag S_M_TOTAL_SAL_EXAMPLE and link it to EW_WAIT.
Share

14. Mapping -> Validate

15. Repo sito ry -> Save.
16 . Run wo rkflo w and see.

Twe e t

Sub mit

G e t th i s

PDFmyURL.com

Reactio ns:

You can follow any responses to this entry through the RSS 2.0 feed. You can leave
a response.

0 Responses
Le ave a R e p ly

Enter your comment...

Comment as:
Publish

Preview

Links to this post

Create a Link

Previous Entries

Next Entries

Recent Comments
PDFmyURL.com

 2009 - Complete reference to Informatica is proudly brought to you by Naveen

PDFmyURL.com