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 |
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
Which kind of index is preferred in DWH?
In warehouses how many schemas are there?
Differentiate between sessions and batches?
How can one identify whether mapping is correct or not without connecting session?
Which is better performance wise database or file?How?
What is the status code in stored procedure transformation?
need for registering a repository server
Why is sorter an active transformation?
What is informatica? What exactly are the practical uses in real world
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
how can import the data from the flat files?