-
-
-
-
-
-
-
-
-
-
-
What is Code Page Compatibility?
Compatibility between code pages is used for accurate data movement when the Informatica Sever runs in the Unicode data movement mode. If the code pages are identical, then there will not be any data loss. One code page can be a subset or superset of another. For accurate data movement, the target code page must be a superset of the source code page.Superset - A code page is a superset of another...
-
Describe two levels in which update strategy transformation sets?
Within a session. When you configure a session, you can instruct the Informatica Server to either treat all records in the same way (for example, treat all records as inserts), or use instructions coded into the session mapping to flag records for different database operations. Within a mapping. Within a mapping, you use the Update Strategy transformation to flag records for insert, delete, update,...
-
What are the new features of the server manager in the informatica 5.0?
U can use command line arguments for a session or batch.This allows U to change the values of session parameters,and mapping parameters and maping variables. Parallel data processing: This feature is available for powercenter only.If we use the informatica server on a SMP system,U can use multiple CPU’s to process a session concurently. Process session data using threads: Informatica server runs the...
-
What is metadata reporter?
It is a web based application that enables you to run reports againist repository metadata. With a meta data reporter,u can access information about U’r repository with out having knowledge of sql,transformation language or underlying tables in the repository.
-
To achieve the session partition what r the necessary tasks u have to do?
Configure the session to partition source data. Install the informatica server on a machine with multiple CPU’s.
-
Why u use repository connectivity?
When u edit,schedule the sesion each time,informatica server directly communicates the repository to check whether or not the session and users r valid.All the metadata of sessions and mappings will be stored in repository.
-
What r the out put files that the informatica server creates during the session running?
Informatica server log: Informatica server(on unix) creates a log for all status and error messages(default name: pm.server.log).It also creates an error log for error messages.These files will be created in informatica home directory. Session log file: Informatica server creates session log file for each session.It writes information about session into log files such as initialization process,creation...
-
What is polling?
It displays the updated information about the session in the monitor window. The monitor window displays the status of each session when U poll the informatica server
-
How can u access the remote source into U’r session?
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 U must configure the FTP connection to the host machine before u create the session. Hetrogenous : When U’r maping contains more than one source type,the server manager creates a hetrogenous session that displays...
-
What r the transformations that restricts the partitioning of sessions?
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 u can not parttion the assosiated source Joiner Transformation : U can not partition the master source for a joiner transformation Normalizer Transformation XML targets.
Informatica Interview Questions
Ans