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
- 8685 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
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.
is it possible to index the data in cache of lkp transformation ?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Suppose we do not group by on any ports of the aggregator what will be the output?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the prerequisite tasks to achieve the session partition?
What is a standalone command task?
What is the need for an etl tool?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
In informatica workflow manager, how many repositories can be created?
How do you handle two sessions in Informatica
Can we create a Integration service without a Repository service and vice versa?
Which files are created during the session rums by informatics server?
How we can create indexes after completing the loan process?
what is the Default Source Option For Update Strategy Transformation?
