How can we create header and footer in target using informatica?

Question

When we do not know the number of targets, Can we create the targets at run time using informatica Powercenter.

Suppose we have below source:
Employee:

Dept_ID      EmpName  Sal
10           A        200
11           B        100
10           C        200
10           D        400
12           E        500
12           F        400

...

It can have any number of distinct Dept_ID. I want to load all EmpName and Sal of a particular Dept_ID into a separate target table (i.e target name should be as Tar_10 or Tar_11 where 10 & 11 are Dept_ID).

Answer 1

The header or footer can be created in the target using the property "append if exist"
Depending on what you need in the header / footer and target data create our mapping. Example 3 flows of data
Source -> transformation for header -> target.txt
Source -> transformation for target data -> target.txt
Source -> transformation for footer -> target.text

Set the target load order as above order and set the target file names as same

Go to session and in properties set file property to APPEND IF EXISTS.

This will append the data in the order specified in target with header, footer

Comments

What is example 3 here?