what is the difference between mapplet & stored procedure?
Answer Posted / dave
Stored Procedures should be pre-built on the database which
can be connected through
Informatica mapplets are built-in in Informatica
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
State the differences between sql override and lookup override?
What is the difference between a connected look up and unconnected lookup?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the data movement modes in informatica?
Which development components of informatica have the highest usage?
how to create user defined function (udf) in informatica
What are the types of lookup transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the tasks that can be performed using sq?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is data movement mode in Informatica and difference between them?
Define update strategy?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What does update strategy mean, and what are the different option of it?