top button
Flag Notify
Site Registration

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

+1 vote
1,400 views
How can we create header and footer in target using informatica?
posted Mar 2, 2016 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

answer Mar 4, 2016 by Vishi Gulati
What is example 3 here?
Similar Questions
+2 votes

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).

+1 vote

If session fails after loading 10000 records in the target, how can we load 10001 the record when we run the session in the next time?

...