What are the reusable transforamtions?
Answers were Sorted based on User's Feedback
Answer / swetha
Reusable transformations can be used in multiple mappings.
When you need to incorporate this transformation into
maping, U add an instance of it to maping. Later if yoU
change the definition of the transformation ,all instances
of it inherit the changes. Since the instance of reusable
transforamation is a pointer to that transforamtion, U can
change the transforamation in the transformation developer,
its instances automatically reflect these changes. This
feature can save yoU great deal of work.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / harithareddy
If you want to perform similar task for diff mappings, and
if your logic is also similar for the diff requirements. in
that case instead of creating multiple mappings, we will
create it once and we will select the option as resuable.
so that we can reuse it in other mappings also.
but if you want to do the modifications in reusable mapping
its not possible. you need to do it in original
transformation it will will reflect all the other instances
of that particular transformation
| Is This Answer Correct ? | 4 Yes | 0 No |
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
Enlist the tasks for which source qualifier transformation is used.
How to load time dimension?
How to generate sequence numbers?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
Parameter and variable differences
In session log thier should not be a single error how will u do
In a table, 4 person having same salary. How to get Third person record only?
How to load the data from a flat file into the target where the source flat file name changes daily?
can a port in expression transf be given the name DISTINCT
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help