Tasks which Load manger process
Elucidate what are the tasks which Load manger process will do?
Expert
Manages the session as well as batch scheduling: When we launch the informatica server the load manager queries and launches the repository for a list of session configured to execute on informatica server. When we configure the session the load manager maintains list of list of sessions and session start times. When we start a session load manger fetches the session information from repository to execute the verifications and validations prior to starting DTM process.
Reading and locking the session: When the informatica server starts a session load manager bolts the session from the repository. Locking prevents starting the session again and again.
Reading the parameter file: If the session uses the parameter files, load manager reads parameter file and finds out that the session level parameters are declared in file
Verifies authorization and privileges: When the session starts load manger check whether or not the users have privilege to execute the session. Creating log files: Load manger makes log file holds the status of a session.
Explain about the Data Storage Definition Language?
Briefly describe the differentiation between Data warehousing and Business Intelligence?
Explain the following term: a) OLAP b) OLTP
Illustrates the term data sparsity and how this effect upon aggregation?
Explain the usage of the repository connectivity?
Explain the reusable transformation?
Specify different types of transformations available in the Informatica?
States the term Global temporary.
Illustrates the term tkprof and how is this used?
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
18,76,764
1960223 Asked
3,689
Active Tutors
1445493
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!