Answer Posted / 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 |
Post New Answer View All Answers
What are the reusable transformations?
To import the flat file definition into the designer where should the flat file be placed?
Name the different lookup cache(s)?
What is status code in informatica?
How can we delete duplicate rows from flat files?
What is session task and command task?
What are active transformations.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How we can use union transformation?
What is a sequence generator transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain pushdown optimization and types in informatica