sir

• Nov 23rd, 2005

Summary filter can be applieid on a group of rows that contain a common value.where as detail filters can be applied on each and every rec of the data base.

Answer Question  Select Best Answer

paul luthra

• Nov 9th, 2005

You can write a mapping with the flat file as a target using a DUMMY_CONNECTION. A flat file target is built by pulling a source into target space using Warehouse Designer tool.

Answer Question  Select Best Answer

Manages the session and batch scheduling: Whe u start the informatica server the load maneger launches and queries the repository for a list of sessions configured to run on the informatica server.When u configure the session the loadmanager maintains list of list of sessions and session start times.When u sart a session loadmanger fetches the session information from the repository to perform the...

AnjiReddy

• Aug 17th, 2005

How can you determine, whether informatica server is running or not with out using event viewer by using shell command. I would appreciate the solution for this one. Feel free to mail me at puli.reddy@gmail.com

Answer Question  Select Best Answer

Lenin

• Nov 2nd, 2005

A TIME DIMENSION is a table that contains the detail information of the time at which a particular 'transaction' or 'sale' (event) has taken place. The TIME DIMENSION has the details of DAY, WEEK, MONTH, QUARTER, YEAR

prasad nallapati

• Aug 25th, 2005

In a relational data model, for normalization purposes, year lookup, quarter lookup, month lookup, and week lookups are not merged as a single table. In a dimensional data modeling(star schema), these...

Answer Question  Select Best Answer

Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target.

khadarbasha

 Profile Answers by khadarbasha Questions by khadarbasha

• Sep 30th, 2005

Performance can be improved by processing data in parallel in a single session by creating multiple partitions of the pipeline.Informatica server can achieve high performance by partitioning the pipleline and performing the extract , transformation, and load for each partition in parallel. 

Answer Question  Select Best Answer

Nagi R Anumandla

• Aug 11th, 2005

Informatica Repository Server:It's manages connections to the repository from client application. Informatica Server:It's extracts the source data,performs the data transformation,and loads the transformed data into the target

Answer Question  Select Best Answer

Kevin B

• Jul 8th, 2005

Download the Document

Kevin B

• Jul 8th, 2005

The Informatica? PowerCenter? Partitioning option optimizes parallel processing on multiprocessor hardware by providing a thread-based architecture and built-in data partitioning. GUI-based tools...

Answer Question  Select Best Answer

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...

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,...

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...

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.

Configure the session to partition source data. Install the informatica server on a machine with multiple CPU’s.

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.

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...

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

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...

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.

U can Debug U’r maping in maping designer U can view the work space over the entire screen The designer displays a new icon for a invalid mapings in the navigator window U can use a dynamic lookup cache in a lokup transformation Create maping parameters or maping variables in a maping or maplet to make mapings more flexible U can export objects into repository and import objects from repository.when...

When using incremental aggregation, you apply captured changes in the source to aggregate calculations in a session. If the source changes only incrementally and you can capture changes, you can configure the session to process only those changes. This allows the Informatica Server to update your target incrementally, rather than forcing it to process the entire source and recalculate the same calculations...

U can shedule a session to run at a given time or intervel,or u can manually run the session. Different options of scheduling Run only on demand: server runs the session only when user starts session explicitly Run once: Informatica server runs the session only once at a specified date and time. Run every: Informatica server runs the session at regular intervels as u configured. Customized repeat:...