informatica faq-12
Q:What is power center repository?
A:The PowerCenter repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, yoYou can create a single global
repository to store metadata used across an enterprise, and a number of local repositories to share the global metadata as needed.
Q:What are the types of metadata that stores in repository?
A:Following are the types of metadata that stores in the repository:-
Database connections
Global objects
Mappings
Mapplets
Multidimensional metadata
Reusable transformations
Sessions and batches
Short cuts
Source definitions
Target defintions
Transformations.
Q:Define Informatica Repository?
A:The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools. Metadata can include information
such as mappings describing how to transform source data, sessions indicating when you want the Informatica Server to perform the transformations, and connect strings
for sources and targets.
The repository also stores administrative information such as usernames and passwords, permissions and privileges, and product version.
Use repository manager to create the repository.The Repository Manager connects to the repository database and runs the code needed to create the repository
tables.Thsea tables stores metadata in specific format the informatica server,client tools use.
Q:What is difference between maplet and reusable transformation?
A:Maplet consists of set of transformations that is reusable.A reusable transformation is a single transformation that can be reusable.
If u create a variables or parameters in maplet that can not be used in another maping or maplet.Unlike the variables that are created in a reusable transformation can be
usefull in any other maping or maplet.
We can not include source definitions in reusable transformations.But we can add sources to a maplet.
Whole transformation logic will be hided in case of maplet.But it is transparent in case of reusable transformation.We cant use COBOL source qualifier,joiner,
normalizer transformations in maplet.Where as we can make them as a reusable transformations.
Q:What are the transformations that restricts the partitioning of sessions?
A:Advanced External procedure tranformation and External procedure transformation: This transformation contains a check box on the properties tab to allow partitioning.
Aggregator Transformation: If u use sorted ports You can not parttion the assosiated source Joiner Transformation :
You can not partition the master source for a joiner transformation
Normalizer Transformation
XML targets.
Q:What is difference between partioning of relatonal target and partitioning of file targets?
A:If u parttion a session with a relational target informatica server creates multiple connections to the target database to write target data concurently.If u partition a
session with a file target the informatica server creates one target file for each partition.You can configure session properties to merge these target files.
Q:How can you access the remote source into your session?
A:Relational source: To acess relational source which is situated in a remote place ,u need to configure database connection to the datasource.
FileSource : To access the remote source file you must configure the FTP connection to the host machine before you create the session.
Hetrogenous : When U’r maping contains more than one source type,the server manager creates a hetrogenous session that displays source options for all types.
Q:What is parameter file?
A:Parameter file is to define the values for parameters and variables used in a session.A parameter
file is a file created by text editor such as word pad or notepad.
You can define the following values in parameter file:-
Maping parameters
Maping variables
session parameters.
Q:What are the session parameters?
A:Session parameters are like maping parameters,represent values you might want to change between sessions such as database connections or source files.
Server manager also allows you to create userdefined session parameters.Following are user defined session parameters:-
Database connections
Source file names: use this parameter when you want to change the name or location of session source file between session runs.
Target file name : Use this parameter when you want to change the name or location of session target file between session runs.
Reject file name : Use this parameter when you want to change the name or location of
session reject files between session runs.
Q:Define maping and sessions?
A: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.
Q:What are the different types of Type2 dimension maping?
A:Type2 Dimension/Version Data Maping: In this maping the updated dimension in the source will gets inserted in target along with a new version number. Newly added
dimension in source will inserted into target with a primary key.
Type2 Dimension/Flag current Maping: This maping is also used for slowly changing dimensions.In addition it creates a flag value for changed or new dimension.
Flag indiactes the dimension is new or newlyupdated.Recent dimensions will gets saved with cuurent flag value 1. And updated dimensions are saved with the value 0.
Type2 Dimension/Effective Date Range Maping: This is also one flavour of Type2 maping used for slowly changing dimensions.This maping also inserts both new and
changed dimensions in to the target. And changes are tracked by the effective date range for each version of each dimension.
A:The PowerCenter repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, yoYou can create a single global
repository to store metadata used across an enterprise, and a number of local repositories to share the global metadata as needed.
Q:What are the types of metadata that stores in repository?
A:Following are the types of metadata that stores in the repository:-
Database connections
Global objects
Mappings
Mapplets
Multidimensional metadata
Reusable transformations
Sessions and batches
Short cuts
Source definitions
Target defintions
Transformations.
Q:Define Informatica Repository?
A:The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools. Metadata can include information
such as mappings describing how to transform source data, sessions indicating when you want the Informatica Server to perform the transformations, and connect strings
for sources and targets.
The repository also stores administrative information such as usernames and passwords, permissions and privileges, and product version.
Use repository manager to create the repository.The Repository Manager connects to the repository database and runs the code needed to create the repository
tables.Thsea tables stores metadata in specific format the informatica server,client tools use.
Q:What is difference between maplet and reusable transformation?
A:Maplet consists of set of transformations that is reusable.A reusable transformation is a single transformation that can be reusable.
If u create a variables or parameters in maplet that can not be used in another maping or maplet.Unlike the variables that are created in a reusable transformation can be
usefull in any other maping or maplet.
We can not include source definitions in reusable transformations.But we can add sources to a maplet.
Whole transformation logic will be hided in case of maplet.But it is transparent in case of reusable transformation.We cant use COBOL source qualifier,joiner,
normalizer transformations in maplet.Where as we can make them as a reusable transformations.
Q:What are the transformations that restricts the partitioning of sessions?
A:Advanced External procedure tranformation and External procedure transformation: This transformation contains a check box on the properties tab to allow partitioning.
Aggregator Transformation: If u use sorted ports You can not parttion the assosiated source Joiner Transformation :
You can not partition the master source for a joiner transformation
Normalizer Transformation
XML targets.
Q:What is difference between partioning of relatonal target and partitioning of file targets?
A:If u parttion a session with a relational target informatica server creates multiple connections to the target database to write target data concurently.If u partition a
session with a file target the informatica server creates one target file for each partition.You can configure session properties to merge these target files.
Q:How can you access the remote source into your session?
A:Relational source: To acess relational source which is situated in a remote place ,u need to configure database connection to the datasource.
FileSource : To access the remote source file you must configure the FTP connection to the host machine before you create the session.
Hetrogenous : When U’r maping contains more than one source type,the server manager creates a hetrogenous session that displays source options for all types.
Q:What is parameter file?
A:Parameter file is to define the values for parameters and variables used in a session.A parameter
file is a file created by text editor such as word pad or notepad.
You can define the following values in parameter file:-
Maping parameters
Maping variables
session parameters.
Q:What are the session parameters?
A:Session parameters are like maping parameters,represent values you might want to change between sessions such as database connections or source files.
Server manager also allows you to create userdefined session parameters.Following are user defined session parameters:-
Database connections
Source file names: use this parameter when you want to change the name or location of session source file between session runs.
Target file name : Use this parameter when you want to change the name or location of session target file between session runs.
Reject file name : Use this parameter when you want to change the name or location of
session reject files between session runs.
Q:Define maping and sessions?
A: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.
Q:What are the different types of Type2 dimension maping?
A:Type2 Dimension/Version Data Maping: In this maping the updated dimension in the source will gets inserted in target along with a new version number. Newly added
dimension in source will inserted into target with a primary key.
Type2 Dimension/Flag current Maping: This maping is also used for slowly changing dimensions.In addition it creates a flag value for changed or new dimension.
Flag indiactes the dimension is new or newlyupdated.Recent dimensions will gets saved with cuurent flag value 1. And updated dimensions are saved with the value 0.
Type2 Dimension/Effective Date Range Maping: This is also one flavour of Type2 maping used for slowly changing dimensions.This maping also inserts both new and
changed dimensions in to the target. And changes are tracked by the effective date range for each version of each dimension.
posted by dwhfaq | 2:04 PM
<< Home