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

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

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

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

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

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

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

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

reddeppa

• Jan 1st, 2006

there is one formula..no.of bloccks=0.9*( DTM buffer size/block size)*no.of partitions.here no.of blocks=(source+targets)*2

pat

• Dec 7th, 2005

The restriction is only on the database side. how many concurrent threads r u allowed to run on the db server?

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

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

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 4th, 2006

Informatica Server Object is must.Cheers,Sithu

reddeppa

• Jan 1st, 2006

Informatica server must run,,

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

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

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

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

Two methods 1.Design it in the transformation developer. 2.Promote a standard transformation from the mapping designer.After U add a transformation to the mapping , U can promote it to the status of reusable transformation. Once U promote a standard transformation to reusable status,U can demote it to a standard transformation at any time. If u change the properties of a reusable transformation in...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

You can design using 2 methodsusing transformation developercreate normal one and promote it to reusable CheersSithu

Praveen Vasudev

• Sep 12th, 2005

PLEASE THINK TWICE BEFORE YOU POST AN ANSWER.Answer: Two methods 1.Design it in the transformation developer. by default its a reusable transform.2.Promote a standard transformation from the mapping d...

Answer Question  Select Best Answer