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
- 8758 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
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
my source is junk data how will u remove that junk data by using unix please any one replay me
Clarify the utilization of aggregator cache record?
is it possible to index the data in cache of lkp transformation ?
Partition, what happens if the specified key range is shorter and longer
lookup transformation with screenshots
How to start a workflow using pmcmd command?
What happens when a session fails and you click on recover?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is the fact table?
What are the types of caches in lookup?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what is unit testing?tell me proceedure
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
explain one complex mapping with logic? sales project?
