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.
Under what conditions should indexes are employed?
Why we use Context? And explain the LOV?
Explain the way to audit the SQL sent to the server.
Differentiate between start schma and Fsldm?
Describe the inconsistent values problem? Comprise an appropriate example?
Explain the term Job parameters?
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
Give brief introduction of the term breakpoint in SSIS?
Explain the extended, standard and secured mode?
States the term Global temporary.
18,76,764
1939847 Asked
3,689
Active Tutors
1412432
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!