what is difference between mapping and mapplet ?
Answers were Sorted based on User's Feedback
Answer / sukanta
Mapping is developed for what data will move to target,what
the modifications done upon that.Mapping is the collection
of source,target,transformations and mapplets.
Mapplets is only collection of transformations.It is a
reusable object and you can use it in any mapping for that
particular folder.Mapplet is meant for a particular complex
work done lets say sale tax calculation.
In mapplet you can use source but can't use another mapplet.
| Is This Answer Correct ? | 14 Yes | 2 No |
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
What is meant by lookup transformation? Explain the types of lookup transformation?
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
in which situations do u go for sequence generator ?
Explain the aggregator transformation?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
Explain in detail about scd type 1 through mapping.
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
why u go for dimensions ?