What is difference between Mapplet and reusable
transformation?
Answer Posted / ravi
MAPPLET IS SET OF REUSABLE TRANSFORMATION,WE CAN USE THIS MAPPLET IN ANY MAPPING WITH IN THE FOLDER
WHERE AS REUSABLE TRANSFORMATION IS SINGLE TRANSFORMATION,WE CAN USE MANY TIMES
*) IF WE CREATE MAPPING VAR OR PARAMETERS IN MAPPLET WE CAN'T USE IN ANOTHER MAPPING (OR) MAPPLET.
WHERE AS *) IF WE CREATE MAPPING VAR OR PARAMETERS IN REUSABLE WE CAN USE IN ANOTHER MAPPING (OR) MAPPLET.
*) IF YOU USE A STORED PROCEDURE TRANSFORMATION, YOU MUST CONFIGURE THE STORED PROCEDURE TYPE TO BE NORMAL.
YOU CANNOT INCLUDE THE FOLLOWING OBJECTS IN A MAPPLET:
1) NORMALIZER T/R
2) COBOL SOURCE
3)XML SOURCE QUALIFIER T/R.
4)XML SOURCE
5) TARGET DEFINITION
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain sql transformation in script mode examples in informatica
What is meant by lookup transformation? Explain the types of lookup transformation?
What do you understand by a term domain?
What is Data Caches size?
Explain load alternative records / rows into multiple targets - informatica
What are the tasks that source qualifier perform?
What is the session task and command task?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is the difference between stop and abort in informatica
where to store informatica rejected data? How to extract the informatica rejected data?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what is diff b/t sorter t/r and agg have the option sorter property...
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
In development project what is the process to follow for an etl developer from day1