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
- 8735 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 |
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
Briefly define a session task?
without dynamic lookup transformation how to insert new rows and update existing rows?
What are the types of presistent cache in look up tr.
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
how many types transformations supported by sortedinput?
Why is sorter an active transformation?
Examples of Fatal & Non-Fatal error?
how to join the 2 different table with different columns in informatica?
How to load a relational source into file taget?
Difference Between ETL & ELT?
Teradata 
