Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 8738 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain about Informatica server process that how it works relates to mapping variables?
Different circumstance which drives informatica server to expel records?
Define update strategy?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
can u give example for factless fact table
Can u generate reports in Informatica?
What differs when we choose the sorted input for aggregator transformation?
How can one identify whether mapping is correct or not without connecting session?
Mention few advantages of router transformation over filter transformation.
How do you take back up of repository?
What is source qualifier transformation in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to create the source and target database connections in server manager?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
