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 |
How mapping parameter and variable works
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How do you load first and last records into target table?
What are Dimensional table?
What is the term PIPELINE in informatica ?
Without using any transformations how u can load the data into target?
What is an incremental loading? in which situations we will use incremental loading
State the limitations where we cannot use joiner in the mapping pipeline?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
What is Session and Batches?
What is staging area?
what is difference between dimention table and fact table?