What are the methods for creating reusable transforamtions?
Answers were Sorted based on User's Feedback
Answer / swetha
Two methods
1.Design it in the transformation developer.
2.Promote a standard transformation from the mapping
designer. After yoU add a transformation to the mapping ,
yoU can promote it to the 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 you change the properties of a reusable transformation in
mapping, yoU can revert it to the original reusable
transformation properties by clicking the revert button.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rekha
TWO WAYS
USING TRANFORMATION DEVELOPER
CREATE THE NORMAL ONE AND PROMOTE IT TO REUSABLE
| Is This Answer Correct ? | 0 Yes | 0 No |
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
Can i create a lookup table without cache.
How many cubes create from a single model?
What is the function of union transformation?
What is joiner cache?
whether Sequence generater T/r uses Caches? then what type of Cache it is
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What are the data movement modes in informatcia?
What does update strategy mean, and what are the different option of it?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
Why we use lookup transformations?
Design a mapping to load the cumulative sum of salaries of employees into target table?