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 term Data mart?
Explain the standard folders?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Explain the difference between ARRAY and STACK in Data Structures?
Explain what is meant by the term enterprise warehouse?
Illustrates the term tkprof and how is this used?
Define the efficient data structure used within the internal storage representation in RDBMS?
Explain the procedure through which an end-user can share user objects with other users?
Explain what is meant by the term universe stage?
Illustrates the term normalization?
18,76,764
1946456 Asked
3,689
Active Tutors
1431224
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!