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

Master thread: Creates and manages all other threads Maping thread: One maping thread will be creates for each session.Fectchs session and maping information. Pre and post session threads: This will be created to perform pre and post session operations. Reader thread: One thread will be created for each partition of a source.It reads data from source. Writer thread: It will be created to load data...

Killer

• Oct 12th, 2006

Yupz this make sense ! =)

Answer Question  Select Best Answer

Yes. By using copy session wizard u can copy a session in a different folder or repository.But that target folder or repository should consists of mapping of that session. If target folder or repository is not having the maping of copying session , u should have to copy that maping first before u copy the session

Prasanna

• Feb 3rd, 2006

In addition, you can copy the workflow from the Repository manager. This will automatically copy the mapping, associated source,targets and session to the target folder.

Answer Question  Select Best Answer

Grouping of session is known as batch.Batches r two types Sequential: Runs sessions one after the other Concurrent: Runs session at same time. If u have sessions with source-target dependencies u have to go for sequential batch to start the sessions one after another.If u have several independent sessions u can use concurrent batches. Whch runs all the sessions at the same time.

sangroover

• Feb 15th, 2006

Batch--- is a group of any thing Different batches ----Different groups of different things.

Answer Question  Select Best Answer

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. U can define the following values in parameter file Maping parameters Maping variables session parameters

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

When you start a workflow, you can optionally enter the directory and name of a parameter file. The Informatica Server runs the workflow using the parameters in the file you specify. For UNIX shell us...

Answer Question  Select Best Answer

Following r 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

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Source definitions. Definitions of database objects (tables, views, synonyms) or files that provide source data. Target definitions. Definitions of database objects or files that contain the target da...

Answer Question  Select Best Answer

The PowerCenter repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, you 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.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Standalone repository. A repository that functions individually, unrelated and unconnected to other repositories. Global repository. (PowerCenter only.) The centralized repository in a domain, a group...

Answer Question  Select Best Answer

To work with remote datasource u need to connect it with remote connections.But it is not preferable to work with that remote source directly by using remote connections .Instead u bring that source into U r local machine where informatica server resides.If u work directly with remote source the session performance will decreases by passing less amount of data across the network in a particular time....

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 27th, 2006

You can work with remote, But you have to  Configure FTPConnection detailsIP addressUser authentication CheersSithu

Answer Question  Select Best Answer

J.David Sukeerthi Kumar

• May 17th, 2007

There is on option called 'COMMIT INTERVAL', (By default its value is 10000 records)That means for every 10000 records? loaded ,the informatica server will issue an COMMIT command.If we specify 'SOUR...

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

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

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

kalyan

• Dec 20th, 2005

haiThe best way  to find out bottlenecks is writing to flat file and see where the bottle neck is .kalyan

Answer Question  Select Best Answer

Vamshidhar

• Jan 11th, 2006

Hi,it depends upon the informatica version we r using. suppose if we r using informatica 6 it supports only 32 partitions where as informatica 7 supports 64 partitions.

Answer Question  Select Best Answer

reddeppa

• Jan 1st, 2006

By using ODBC connection.if it is relational.if is flat file FTP connection..see we can make sure with connection in the properties of session both sources && targets.

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 1st, 2006

it's  very easyActually oracle 8i not allowed userdefined data typesbut 9i allowsand then blob,clob allow only 9i not 8iand  more over list partinition is there in 9i only

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

Normalizer: It is a transormation mainly using for cobol sources,it's change the rows into coloums and columns into rowsNormalization:To remove the retundancy and inconsitecy

Answer Question  Select Best Answer

gauravkant

 Profile Answers by gauravkant Questions by gauravkant

• Feb 13th, 2006

Hi,For version control in ETL layer using informatica, first of all after doing anything in your designer mode or workflow manager, do the following steps.....1> First save the changes or new imple...

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

simply man,Cleansing:---TO identify and remove the retundacy and inconsistencysampling: just smaple the data throug send the data from source to target

Answer Question  Select Best Answer

suresh maddineni

• May 14th, 2006

3 layersgraph development environmentcooperating systementerprise metadata environment

Answer Question  Select Best Answer