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
- 8871 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
Under what condition selecting sorted input in aggregator may fail the session?
pmscmd startworkflow -sv
How to extract sap data using informatica?
What is the function of look up transformation?
Explain lookup transformation source types in informatica
What is the status code in stored procedure transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is an expression transformation?
What are the new features of informatica 9.x developer?
What is the difference between a repository server and a powerhouse?
What is repository manager?
What are the transformations that are not supported in mapplet?
Define the various join types of joiner transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Design time, run time. If you don't create parameter what will happen
