Why can't we use few transformations in mapplet ? like xml
and target defintions, seq etc ?
Answer Posted / 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 |
Post New Answer View All Answers
in reporting we add some new objects,how we get the count of the newly added objects to the report
Briefly explain the aggregator transformation?
Enlist the advantages of informatica.
Explain the scenario which compels informatica server to reject files?
what is informatica metadata?
Please let me know how to make encryption and decryption with example?
How you can differentiate between connected lookup and unconnected lookup?
Differentiate between joiner and lookup transformation?
How to open an older version of an object in the workspace?
difference between informatica 8.1.1 and 8.6
what is SDLC way of code development?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the limitations of joiner transformation?
What are the different lookup cache(s)?