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
- 8689 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Have you worked with/created Parameter file
What are active transformations.
if the session fails after 100 records agian we have to starts the session or we go for recovery session
What is a connected transformation?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
Tell me about MD5 functions in informatica
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Enlist few areas or real-time situations where informatica is required.
What are the new features of informatica 7.1?
I have 1200 records how can u send it in aggregator with good performance issues?
Is there any model difference between ODS and DWH
Teradata 
