Session and Batches
Describe briefly the term Session and Batches?
Expert
Session - A Session Is A set up of instructions which tell the Informatica Server How and When to shift Data from Sources to the Targets. After making the session, we can employ either the server manager or command line program pmcmd to stop or start the session.
Batches - It offers A Way to Group Sessions for Either Parallel or Serial Execution through the Informatica Server.
There Are Two Types of Batches which are illustrated below:
i) Sequential - Run Session One after Other. ii) Concurrent - Run Session at the similar Time.
Explain the hot backup in case of Oracle.
How can we increase the performance within the Data Stage?
Explain the term queue in data structure? Answer: In data structure a queue is a sequential organization of data. It is a first in first out i.e. FIFO type of data s
Specify the data units at the different layers of TCP / IP protocol suite?
Explain the term Business Objects Repository?
What is cmaxpktsz good for in Sybase?
What do you understand by the term deadlock in DBMS? How can it be avoided? How can it be solved once it happens?
What is the main dissimilarity between horizontal and vertical partitioning?
Write a short on the six database functions which occur during the systems development life cycle?
Describe briefly the different methods of loading Dimension tables?
18,76,764
1942372 Asked
3,689
Active Tutors
1435575
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!