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
Name the different lookup cache(s)?
In which transformation you cannot drag ports into it?
Define sessions in informatica etl?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is a node in Informatica?
Is it possible to use a client with different version than that of its Informatica server?
EXL informatica Questions
What are the advantages of informatica?
Enlist few areas or real-time situations where informatica is required.
what is the -ve test case in your project.
Explain the etl program with few examples.
What are the mapping parameters and mapping variables?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Where can we find the throughput option in informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks