What are the reusable transforamtions?

Answers were Sorted based on User's Feedback



What are the reusable transforamtions?..

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

What are the reusable transforamtions?..

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

Post New Answer

More Informatica Interview Questions

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  


wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,


In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,


how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,


I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  






select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,


Differentiate between sessions and batches?

0 Answers  


Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,


where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  


How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,


when informatica 8 series released ?

1 Answers   IBM,


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


Categories