Why can't we use few transformations in mapplet ? like xml
and target defintions, seq etc ?
Answers were Sorted based on User's Feedback
Answer / ankur saini
i think we cant use target , seq etc in the mapplets
becuase this will restrict the basic need for which
mapplets are, that is re-usability...if you are using same
target then it wouldnt be reusable right. Mapplet is a set
of trancformations you use to load diff targets i would say.
same is the case with seq generator ..say you have a maplet
with a seq gen ...this is being used in two diff
mappings...then that seq gen will generate one set or seq
no for one mapping and anothe set for other mapping say
1,2,3 for first mapping and 4,5,6 for 2nd mapping but this
is not reusablitiy!!!!
| Is This Answer Correct ? | 3 Yes | 0 No |
How to update records in Target, without using Update Strategy?
What do you understand by a term domain?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the mapping parameters and mapping variables?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
why sequence generator should not directly connected to joiner transformation ?
1 lac of flat fles in source how to load target at a time?
If u r using dynamic cache lookup port will be thier in thet which option u will select
What is A complex mapping?
What are the types of error logs available in Informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Insert else update option in which situation we will use