PREVIOUS

Difference between the source filter and filter?

Source filter is filtering the data only relational sources. Where as filter transformation filter the data any type of source.


what is a tracing level?

Amount of information sent to log file.


What are the types of tracing levels?

Normal,Terse,verbose data,verbose intitialization.


Expalin sequence generator transformation?

Sequence generator transformation is used to generate sequence of numbers. It is substitute to the Primary key. There should be atleast one current value to generate Next value.


Can you connect multiple ports from one group to multiple transformations?

Yes


Can you connect more than one group to the same target or transformation?

NO


What is a reusable transformation?

Reusable transformation can be a single transformation.This transformation can be used in multiple mappings.when you need to incorporate this transformation into mapping you add an instance of it to mapping.

Later if you change the definition of the transformation, all instances of it inherit the changes.Since the instance of reusable transformation is a pointer to that transformation.U can change the transformation in the transformation developer, its instance automatically reflect these changes. This feature can save U great deal of work.


What are the methods for creating reusable transformation?

Two methods

First method is through Transformation Developer. and Second is by Mapplet.


Design it in the transformation developer.

Promote a standard transformation from the mapping designer.After you add a transformation to the mapping, you can promote it to status of reusable transformation.

Once you promote a standard transformation to reusable status, you can demote it to a standard transformation at any time.

If u change the properties of a reusable transformation in mapping , you can revert it to the original reusable transformation properties by clicking the revert.

NEXT