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 way of transactions in Sybase. How it relates with partition assignment.
Write down the differentiation between lookup and filter transformation?
What is Relational Algebra?
Name the methods that are available in storing sequential files?
What can be done with the Data Stage Director?
Explain the security aspects of stored procedures.
Illustrates the difference between a user’s defined function and a stored procedure?
What do you understand by the term cascading update in DBMS?
What are sequences, and what are the possible problems when employing them to make surrogate keys?
State difference between Passive and Active transformation?
18,76,764
1927483 Asked
3,689
Active Tutors
1435893
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!