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 |
Parameter and variable differences
Describe two levels in which update strategy transformation sets?
update strategy transformation in informatica
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
what are 3 tech challenges/ common issues you face?
where to store informatica rejected data?
What are the popular informatica products?
What is facttable granularity?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is substr in informatica?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
Explain the types of lookup transformation?