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 |
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
how to import multiple flat files in to single target where there is no common column in the flat files
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
how to insert header after each group.
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
version controlling in informatica?
Define Incremental Aggregation?
can we use cartesian join in informatica
Can you copy the session to a different folder or repository?
Define update strategy?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Implementation methodology