Interested to Buy Any Domain ? << Click Here >> for more details...
how to work with mapplet designer in informatica?
- 7 Answers
- 24778 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 |
Enlist the differences between database and data warehouse.
Define mapping and session?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
generate Unique sequence numbers for each partition in session with Unconnected Lookup ? Hi All, Please help me to resolve the below issue while Applying partitioning concept to my Session. This is a very simple mapping with Source, Lookup , router, and target. I need to Lookup on the target and compare with the source data, if any piece of data is new then Insert, and If any thing change in the existed data then Update. while Inserting the new records to the target table I'm generating sequence numbers with Unconnected lookup, by calling the maximum PK ID from the target table. The above flow is working fine from last one year. Now I wish to apply the Partitioning concept to the above floe(session) At source I used 4 pass through partitions.(For Each partition different filter conditions to pull the data from source) at Target I used 4 passthrough Partitions. it is working fine for some data, but for some rows for Insert Operation , it is throwing Unique key errors, because while Inserting the data it is generating the same sequence key twice. In detail : 1st row is coming from 1st partition and generated the sequence number 1 for that row. 2nd row is coming from 1st partition and generated the sequence number 2 for that row 3rd row is coming from the 2nd partition generated the sequence number 2 again for that row. (it must generate 3 for this row) the issue is becuase of generating the same sequence numbers twice for different partitions. Can any one Please help me to resolve this issue. While Applying partitions how can I generate a Unique Sequence numbers from Unconnected lookup for Each partitioned data. Regrads, N Kiran.
How to load the data from people soft hrm to people soft erm using informatica?
How will you update the row without using update statergy?
How to load a Dimension ? and how to load a fact table?
What are the static cache and dynamic cache in informatica?
what r the values tht r passed between informatics server and stored procedure?
How to generate or load values in to the target table based on a column value using informatica etl tool.
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
Teradata 
