What is difference between maplet and reusable
transformation?
Answers were Sorted based on User's Feedback
Answer / ravi
Mapplet:this is a set of transformation that can be made
reusable.Reusable T/F is a single transformation which can
be made reusable.
Parameter and variable defined in Mapplet can not be used
in other mapping or mapplets but which defined in reusable
T.F can be used in other mappings/mapplets.
cobol,normalizer,xml can not be used in mapplet but they
can be made reusable.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / mahesh
Mapplet consists of set of transformations that is
reusable. A reusable transformation is a
single transformation that can be reusable.
| Is This Answer Correct ? | 6 Yes | 0 No |
How to delete the data in the target table after loaded.
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
if we have a delimiters at unwanted places in a flat file how can we over come those.
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
How to do the error handling of if ur source is flatfiles?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
major difference between normal loading and bulk loading?
If we are using an aggregator but forget to mention the group by port .what will be the output??
what are the fact table & dimensional table in pharmaceutical and hospotal related products???