how to work with mapplet designer in informatica?
- 7 Answers
- 22349 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
a Mapplet is a set of transformations which can be reused
across multiple mappings. a mapplet cannot have a target.
it can start with a source or a mpplet i/p transformation
and it should end with a mapplet output transformation. you
cannot have a transaction control transformation as part of
a mapplet. also a seq.generator is not permitted.
| Is This Answer Correct ? | 26 Yes | 1 No |
mapplet is is a set of transformations wch can be
reused.mapple can be slected in mapplet.
| Is This Answer Correct ? | 29 Yes | 8 No |
Answer / padmavathi
In Mapplet Designer we will get 2 extra Transformations
like Mapplet Input & Mapplet Output we have to use these as
Input & output Transformations in pipeline, in Middle of
pipe line we have to implement our logic by using
Transformations acc to requirment. This mapplet is
reusable,in Mapping Designer where ever we require tht
logic we can use mapplet directly need not to implement
total logic again just we have to link in/out ports.
| Is This Answer Correct ? | 23 Yes | 3 No |
Answer / usha
mapplet designer which is used to create a mapplet..
mapplet is a set of reusable transformation logic...
mapplet contains mapplet input tarnsfromation ,
mapplet output tarnsfromation,
and some reuasable transformation in the middle of mapplet
i/p and o/p.......
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ryan jasper diego
1. Tools->mappletdesigner->create->give a name
2. From tr menu->create->mapplet input
3. In, mapplet input tr create required ports
4. Create required group of tr like sorter,exp
5. Drag the ports from mapplet input to the tr
6. Create mapplet output t/r
and finally save the mapplet in the repository
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sankar
Mapplet Contains set of Transformations.This Transformations
are reusable transformations and mapplet also. any ware we
can use this mapplets in mapping. Mapplet having Input and
Output mapplet in this mid of we can use different
transformations based on the requirement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Difference between Target-based loading and constraint-based loading?
What is a candidate key?
how to call lookup qualifer in unconnected look;up
what is the difference between Informatica 7.1 and Abinitio?
What is IQD file?
What are the phases in SDLC?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
what is the necessity to use update strategy?(except for updates)
Can yoU use the maping parameters or variables created in one maping into another maping?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
Teradata 
