Modes of data movement in Informatica Server
Specify the 2 modes of data movement in the Informatica Server?
Expert
Two modes of data movement are:
Normal Mode where for every record the separate DML stmt will be prepared and executed.
Bulk Mode where for multiple records DML stmt will be prepared and executed hence, improves the performance.
Explain the automated document scheduling and distribution?
Illustrates the difference between a user’s defined function and a stored procedure?
Describe briefly the difference between pessimistic locking and optimistic locking?
Illustrates the term data structure node class?
Give a brief introduction of the term analysis service?
Explain the mapping of ERD to DFD?
Briefly describe the differentiation between data warehousing and data mining ?
Explain what is meant by the WebI or Web Intelligence?
What is meant by the Surrogate key?
Name the methods and types of Collision Resolution Techniques used in each of the type?
18,76,764
1928062 Asked
3,689
Active Tutors
1416850
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!