After a load is done to my target table, I need to insert a last row, which

After a load is done to my target table, I need to insert a
last row, which might be formed at some expression
transformation and brought to target. Do I have to have
separate mapping to be run after the 1st mapping? Or in a
single mapping how to achieve this?

Question Posted / suresh

3 Answers
8614 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

After a load is done to my target table, I need to insert a last row, which might be formed at ..

Answer / arun

Guess the questione was something different. Need is to add a footer record at the end of the target. This can be done with one mapping, have two pipelines.
1) TO load to target
2) To Load last record to target.

Change the target load plan, to make sure the last record pipeline runs last.

Is This Answer Correct ?

6 Yes

0 No

After a load is done to my target table, I need to insert a last row, which might be formed at ..

Answer / sp

This can be done by defining the target load plan in the developer. You can define two instance of the target and use the same SQ with Expression to load the last row to the second instance of the target. The second instance will be set to load at last in the load plan.

Is This Answer Correct ?

2 Yes

0 No

After a load is done to my target table, I need to insert a last row, which might be formed at ..

Answer / priyank

Use the below pipeline.

SQ -->EXP1-->EXP2-->EXP3------------------> UNION --> TGT
--> SEQ --> AGG --> FLT --> EXP4

1. SEQ: Use a Sequence Generator to generate sequence.
Connect the NEXTVAL port to exp2.
2. From EXP2, take out 2 pipelines, one with actual data and
one with next val.
3. In AGG, COUNT(*).
4. In FLT, NEXTVAL=COUNT(*)
5. In UNION, merge EXP3 and EXP4
6. Push the output from UNION to TGT.

Is This Answer Correct ?

0 Yes

5 No

Post New Answer