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 |
How to load relational source into file target?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
How to eliminate duplicates in FF and oracle both
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
Different qualification between a related rotate toward the sky and isolates look upward?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
What is Target Update Override? What is the Use ?
What are the various types of transformation?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?