31.Name four output files that informations server creates during session running?
A stored procedure transformation is an important tool for populating and maintaing databases.
33.What are the difference between static cache and dynamic cache?
Dynamic cache decreases the performance in comparision to static cache.
Static cache do not see such things just insert data as many times as it is coming
34.Define maping and sessions?
Maping: It is a set of source and target definitions linked by transformation objects that define the rules for transformation.
Session : It is a set of instructions that describe how and when to move data from source to targets.
35.What is a command that used to run a batch?
pmcmd is used to start a batch.
36.What is Datadriven?
The informatica server follows instructions coded into update strategy transformations with in the session mapping determine how to flag records for insert, update, delete or reject.
37.What is power center repository?
The Power Center repository allows you to share metadata across repositories to create a data mart domain.
38.What is parameter file?
A parameter file is a file created by text editor such as word pad or notepad. U can define the following values in parameter file.
Mapping parameters Mapping variables session parameters.
39.What are the types of look up caches?
Static cache Dynamic cache Persistent cache Shared cache Re-cache.
40.What are Stored Procedure transformation?
Stored Procedure transformation is an Passive & Connected or Unconnected transformation. It is useful to automate time-consuming tasks and it is also used in error handling, to drop and recreate indexes and to determine the space in database, a specialized calculation.
Share This :
- Session Lg
- Workflow Log
- Errors Log
- Badfile
A stored procedure transformation is an important tool for populating and maintaing databases.
33.What are the difference between static cache and dynamic cache?
Dynamic cache decreases the performance in comparision to static cache.
Static cache do not see such things just insert data as many times as it is coming
34.Define maping and sessions?
Maping: It is a set of source and target definitions linked by transformation objects that define the rules for transformation.
Session : It is a set of instructions that describe how and when to move data from source to targets.
35.What is a command that used to run a batch?
pmcmd is used to start a batch.
36.What is Datadriven?
The informatica server follows instructions coded into update strategy transformations with in the session mapping determine how to flag records for insert, update, delete or reject.
37.What is power center repository?
The Power Center repository allows you to share metadata across repositories to create a data mart domain.
38.What is parameter file?
A parameter file is a file created by text editor such as word pad or notepad. U can define the following values in parameter file.
Mapping parameters Mapping variables session parameters.
39.What are the types of look up caches?
Static cache Dynamic cache Persistent cache Shared cache Re-cache.
40.What are Stored Procedure transformation?
Stored Procedure transformation is an Passive & Connected or Unconnected transformation. It is useful to automate time-consuming tasks and it is also used in error handling, to drop and recreate indexes and to determine the space in database, a specialized calculation.
0 comments:
Post a Comment