What are the methods for creating reusable transforamtions?




Answers were Sorted based on User's Feedback



What are the methods for creating reusable transforamtions?..

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

What are the methods for creating reusable transforamtions?..

Answer / rekha

TWO WAYS
USING TRANFORMATION DEVELOPER
CREATE THE NORMAL ONE AND PROMOTE IT TO REUSABLE

Is This Answer Correct ?    0 Yes 0 No

Post New Answer




More Informatica Interview Questions

How can the following be achieved in 1 single Informatica Mapping. * If the Header table record has error value(NULL) then those records and the corresponding child records in the SUBHEAD and DETAIL tables should also not be loaded into the target(TARGET1,TARGET 2 or TARGET3). * If the HEADER table record is valid, but the SUBHEAD or DETAIL table record has an error value (NULL) then the no data should be loaded into the target TARGET1,TARGET 2 or TARGET3. * If the HEADER table record is valid and the SUBHEAD or DETAIL table record also has valid records only then the data should be loaded into the target TARGET1,TARGET 2 and TARGET3. =================================================== HEADER COL1 COL2 COL3 COL5 COL6 1 ABC NULL NULL CITY1 2 XYZ 456 TUBE CITY2 3 GTD 564 PIN CITY3 SUBHEAD COL1 COL2 COL3 COL5 COL6 1 1001 VAL3 748 543 1 1002 VAL4 33 22 1 1003 VAL6 23 11 2 2001 AAP1 334 443 2 2002 AAP2 44 22 3 3001 RAD2 NULL 33 3 3002 RAD3 NULL 234 3 3003 RAD4 83 31 DETAIL COL1 COL2 COL3 COL5 COL6 1 D001 TXX2 748 543 1 D002 TXX3 33 22 1 D003 TXX4 23 11 2 D001 PXX2 56 224 2 D002 PXX3 666 332 ======================================================== TARGET1 2 XYZ 456 TUBE CITY2 TARGET2 2 2001 AAP1 334 443 2 2002 AAP2 44 22 TARGET3 2 D001 PXX2 56 224 2 D002 PXX3 666 332

3 Answers   Mphasis, IBM,


How might you approve all mappings in the archive all the while?

0 Answers  


How do you handle two sessions in Informatica

0 Answers   Informatica,


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  


What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,






Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   Qualcomm, iGate,


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


What is dimensional table?

0 Answers  


In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,


What is DTM process?

4 Answers  


Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  


Kimball and Inmon methodologies?

2 Answers  






Categories