top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Can we create the targets at run time using informatica Powercenter

+2 votes
382 views

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

posted Oct 7, 2014 by Sunil

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

1 Answer

0 votes

You can achieve this by the following method:
1.While creating the target check the include file name port checkbox.
2.Use an expression to create the file name port name, something like " 'Tar' || Dept_ID" should do.
3.Use a sorter to sort your input with respect to Dept_ID.
4.Use a transaction control transformation on the condition that when Dept_ID is different from previous Dept_ID use "TC_COMMIT_AFTER", this will keep changing the file name depending on your input.

Your Output will look like this : TAR_10

10 A 200

10 C 200

10 D 400

TAR_11

11 B 100

TAR_12

12 E 500

12 F 400

answer Oct 8, 2014 by Shweta Singh
Similar Questions
0 votes

I have employee's leaves related data and payment related information. e.g. Employee E1 has taken maternity leave this year. She needs to paid for 6 months and if she is on leave for greater duration (like 8 months) , I need to create two records for her.

One for the allowed duration and the other for extended duration.

Employee  LeaveStartDAte  LeaveEndDate Total_days_taken  Total_days_allowed LeaveType
e1         1Jan2013       31Aug2013     242                 186                 ML

Target expected :

Employee  LeaveStartDAte  LeaveEndDate Leavetype
e1        1Jan2013        30June2013     ML
e1        1July 2013      31Aug2013      Extended ML

How can create the second record dynamically in informatica mapping?

0 votes

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

+1 vote

I have a complex XML document that the informatica XML parser struggles with "normalizing", how can I run a XML transformation such as XSLT to simplfy it prior to sending it into the XML parser.

+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?

...