Static cache Dynamic cache U can not insert or update the cacheU can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache when the condition is true.When the condition is not true, informatica server returns the default value for connected transformations and null for unconnected transformations.The informatic server inserts rows into...

vp

• Mar 6th, 2006

lets say for example your lookup table is your target table. So when you create the Lookup selecting the dynamic cache what It does is it will lookup values and if there is no match it will insert th...

Answer Question  Select Best Answer

When the informatica server runs in the ASCII data movement mode it sorts session data using Binary sortorder.If U configure the seeion to use a binary sort order,the informatica server caluculates the binary value of each string and returns the specified number of rows with the higest binary values for the string.

phani

• Dec 9th, 2005

When Informatica Server runs in UNICODE data movement mode ,then it uses the sort order  configured in session properties.

Answer Question  Select Best Answer

The Designer automatically creates a RANKINDEX port for each Rank transformation. The Informatica Server uses the Rank Index port to store the ranking position for each record in a group. For example, if you create a Rank transformation that ranks the top 5 salespersons for each quarter, the rank index numbers the salespeople from 1 to 5:

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 12th, 2006

Based on which port you want generate Rank is known as rank port, the generated values are known as rank index.Cheers,Sithu

Answer Question  Select Best Answer

Join data originating from same source data base. Filter records when the informatica server reads source data. Specify an outer join rather than the default inner join specify sorted records. Select only distinct values from the source. Creating custom query to issue a special SELECT statement for the informatica server to read source data.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 24th, 2006

Join data originating from the same source database. You can join two or more tables with primary-foreign key relationships by linking the sources to one Source Qualifier. Filter records when the Info...

Answer Question  Select Best Answer

U specify the target loadorder based on source qualifiers in a maping.If u have the multiple source qualifiers connected to the multiple targets,U can designatethe order in which informatica server loads data into the targets.

saritha

• Mar 1st, 2006

A target load order group is the collection of source qualifiers, transformations, and targets linked together in a mapping.

Answer Question  Select Best Answer

Simple Pass through maping : Loads a static fact or dimension table by inserting all rows. Use this mapping when you want to drop all existing data from your table before loading new data. Slowly Growing target : Loads a slowly growing fact or dimension table by inserting new rows. Use this mapping to load new data when existing data does not require updates.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

1. Simple Pass through2. Slowly Growing TargetCheers,Sithu

Answer Question  Select Best Answer

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

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 4th, 2006

Type21. Version number2. Flag3.DateCheers,Sithu

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

For a relational sources informatica server creates multiple connections for each parttion of a single source and extracts seperate range of data for each connection.Informatica server reads multiple partitions of a single source concurently.Similarly for loading also informatica server creates multiple connections to the target and loads partitions of data concurently. For XML and file sources,informatica...

durga

• Feb 13th, 2006

Fine explanation

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

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