-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
what are the diffrences between Business Objects 5.1 & 6.5 ?
any body please help me with BO's diffrences
-
-
-
-
-
What is a linked cube?
A cube can be stored on a single analysis server and then defined as a linked cube on other Analysis servers. End users connected to any of these analysis servers can then access the cube. This arrangement avoids the more costly alternative of storing and maintaining copies of a cube on multiple analysis servers. linked cubes can be connected using TCP/IP or HTTP. To end users a linked cube looks like...
-
-
-
-
-
-
-
What is the drill up , drill down, drill by , drill trough ?
drill up : One level up in the HirearchyDrill down: One level down in the Hirearchydrill by : direct selection of level in the Hirearchydrill trough : to drill data from one Hirearchy to another Hirearchy
-
-
Compare Data Warehouse database and OLTP database?
The data warehouse and the OLTP data base are both relational databases. However, the objectives of both these databases are different. The OLTP database records transactions in real time and aims to automate clerical data entry processes of a business entity. Addition, modification and deletion of data in the OLTP database is essential and the semantics of the application used in the front end impact...
-
What is the difference between Data Warehouse and online Analytical Processing?
Ralph Kimball the co-founder of the data warehousing concept has defined the data warehouse as a “"a copy of transaction data specifically structured for query and analysis”. Both definitions highlight specific features of the data warehouse. The former definition focuses on the structure and organization of the data and the latter focuses upon the usage of the data. However, a listing of the features...
-
Online Analytical Processing?
Online Analytical Processing A tool to evaluate and analyze the data in the data warehouse using analytical queries. A tool which helps organize data in the data warehouse using multidimensional models of data aggregation and summarization. Supports the data analyst in real time and enables online analysis of data with speed and flexibility.
-
What is Data Warehouse
Data Warehouse Data from different data sources is stored in a relational database for end use analysisData from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns. Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online...
-
What is stored procedure?
A program running in the database that can take complex actions based on the inputs you send it. Using a stored procedure is faster than doing the same work on a client, because the program runs right inside the database server. Stored procedures are nomally written in PL/SQL or Java.
-
How do you design a universe?
The design method consists of two major phases. During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.During...
-
What is Designer?
Designer is a BusinessObjects IS module used by universe designers to create and maintain universes. Universes are the semantic layer that isolates end users from the technical issues of the database structure. Universe designers can distribute universes to end users by moving them as files through the file system, or by exporting them to the repository.
-
Workgroup mode
A work mode whereby a designer creates universes in an environment without a repository. The mode in which a universe is saved determines whether other designers are able to access it. By default, a universe is saved in the mode in which the designer is already working.
-
User object
An object created by the end user from the BusinessObjects User module. A user object can be inserted into a universe by the designer.
-
Universe domain
The area of the repository that holds exported universes. The universe domain makes it possible to store, distribute, and administrate universes. There may be multiple universe domains in a repository.
-
Universe
A mapping of the data structure found in databases: tables, columns, joins, etc. A universe, which is made up of classes, objects, and conditions, can represent any specific application, system, or group of users.
-
Subclass
A component within a class that groups objects. A subclass can itself contain other subclasses or objects.
-
Structure pane
The graphical component within the main Designer window that shows the schema of the universe. It reflects the underlying database structure of the universe.
-
Strategy
Scripts that automatically extract structural information about tables, columns, joins, or cardinalities from a database. Designer provides default strategies but a designer can also create strategies. These are referred to as external strategies.
-
Shared connection
A shared connection is used to access common resources such as universes or documents. It can be used by several users. Information about a shared connection is stored in a SDAC.LSI or SDAC.SSI file; its definition is updated dynamically.
-
Secured connection
A secured connection is used to access universes or documents that may be restricted or confidential. It can be shared by several authorized users. Stored in the repository, the definition of a secured connection is updated dynamically.
-
Quick Design
A wizard in the Designer module that provides guided instructions for creating a basic universe. It lets a designer name a universe, set up a connection to a database, select strategies, create classes and objects, as well as generate joins with cardinalities.
-
Query
In Designer a query is a technique for creating or modifying a list of values associated with an object. From the Query Panel, a designer builds a query from the classes, objects, and conditions of a universe. In the BusinessObjects User module, a query is a type of data provider. An end user builds a query from a universe, and then runs the query to generate a BusinessObjects report.
-
Qualification
A property of an object that determines how it can be used in multidimensional analysis. An object can be qualified as one of three types: a dimension, detail or measure.
-
Personal connection
A personal connection is used to access resources such as universes or documents. It can be used only by the user who created it. Information about a personal connection is stored in both the PDAC.LSI and PDAC.SSI files; its definition is static and cannot be modified.
-
Offline mode
The work mode in which the designer works with universes stored locally.
-
Measure object
An object that is derived from an aggregate function. It conveys numeric information by which a dimension object can be measured.
-
Loop
A situation that occurs when more than one path exists from one table to another in the universe.
-
List of values
A list of values contains the data values associated with an object. These data values can originate from a corporate database, or a flat file such as a text file or Excel file. In Designer you create a list of values by running a query from the Query Panel. You can then view, edit, purge, refresh and even export this file. A list of values is stored as an .lov file in a subfolder of the UserDocs folder.
-
Join
A relational operation that causes two tables with a common column to be combined into a single table. Designer supports equi-joins, theta joins, outer joins, and shortcut joins.
-
Hierarchy
An ordered series of related dimensions used for multidimensional analysis.
-
Enterprise mode
A work mode whereby a designer creates universes in an environment with a repository. The mode in which a universe is saved determines whether other designers are able to access it. By default, a universe is saved in the mode in which the designer is already working.
-
Document domain
The area of the repository that stores documents, templates, scripts, and lists of values.
-
Dimension object
An object being tracked in multidimensional analysis; the subject of the analysis. Dimensions are organized into hierarchies.
-
Context
A method by which Designer can decide which path to choose when more than one path is possible from one table to another in the universe.
-
Connection
Set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and path to the database. Designer provides three types of connections: secured, shared, and personal.
-
Condition
A component that controls the type and the amount of data returned by a specific object in a query. A condition created in the Designer module is referred to as a predefined condition.
-
Class
A logical grouping of objects and conditions within a universe. In general, the name of a class reflects a business concept that conveys the category or type of objects.
-
Cartesian product
A situation in which a query includes two or more tables that are not linked by a join. If executed, this type of query retrieves all possible combinations between each table and may lead to inaccurate results.
-
Cardinality
Expresses the minimum and the maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0,1, or N.
-
Alias
A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins.
-
-
-
Which two statements are true about a foreign key?
Each Foreign Key must exist as a Primary Key.Foreign Keys can change values over time.
-
What is a common data source for the central enterprise data warehouse?
operational data stores
-
-
What is an alias and how does it differ from a synonym?
An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.
-
What do the initials DDL and DML stand for and what is their meaning?
DDL is data definition language and DML is data manipulation language. DDL statements are CREATE, ALTER, TRUNCATE. DML statements are SELECT, INSERT, DELETE and UPDATE.
-
How can u work with remote database in informatica?did u work directly by using remote connections?
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....
-
What is power center repository?
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.
-
What r the types of metadata that stores in repository?
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
-
Define informatica repository?
The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools. Metadata can include information such as mappings describing how to transform source data, sessions indicating when you want the Informatica Server to perform the transformations, and connect strings for sources and targets. The repository also stores administrative...
-
What is difference between maplet and reusable transformation?
Maplet consists of set of transformations that is reusable.A reusable transformation is a single transformation that can be reusable. If u create a variables or parameters in maplet that can not be used in another maping or maplet.Unlike the variables that r created in a reusable transformation can be usefull in any other maping or maplet. We can not include source definitions in reusable transformations.But...
-
What is parameter file?
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
-
Can u generate reports in Informatcia?
Yes. By using Metadata reporter we can generate reports in informatica.
-
What r the different types of Type2 dimension maping?
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...
-
What r the types of maping in Getting Started Wizard?
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.
-
What r the types of maping wizards that r to be provided in Informatica?
The Designer provides two mapping wizards to help you create mappings quickly and easily. Both wizards are designed to create mappings for loading and maintaining star schemas, a series of dimensions related to a central fact table. Getting Started Wizard. Creates mappings to load static fact and dimension tables, as well as slowly growing dimension tables. Slowly Changing Dimensions Wizard. Creates...
-
What is Datadriven?
The informatica server follows instructions coded into update strategy transformations with in the session maping determine how to flag records for insert, update, delete or reject. If u do not choose data driven option setting,the informatica server ignores all update strategy transformations in the mapping.
-
what is update strategy transformation ?
This transformation is used to maintain the history data or just most recent changes in to target table.
-
What is the default join that source qualifier provides?
Inner equi join.
-
What r the tasks that source qualifier performs?
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.
-
What is source qualifier transformation?
When U add a relational or a flat file source definition to a maping,U need to connect it to a source qualifer transformation.The source qualifier transformation represnets the records that the informatica server reads when it runs a session.
-
Why we use stored procedure transformation?
For populating and maintaining data bases.
-
What r the types of groups in Router transformation?
Input group Output group The designer copies property information from the input ports of the input group to create a set of output ports for each output group. Two types of output groups User defined groups Default group U can not modify or delete default groups.
-
What is the Router transformation?
A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. However, a Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. A Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions...
-
What is the Rankindex in Ranktransformation?
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:
-
Which transformation should we use to normalize the COBOL and relational sources?
Normalizer Transformation. When U drag the COBOL source in to the mapping Designer workspace,the normalizer transformation automatically appears,creating input and output ports for every column in the source.
-
What r the types of lookup caches?
Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the persistent cache is not synchronized with he lookup table,U can configure the lookup transformation to rebuild the lookup cache. Static cache: U can configure a static or readonly cache for only lookup table.By...
-
What r the types of lookup?
Connected and unconnected
-
what is the look up transformation?
Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym. Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table column values based on the look up condition.
-
What r the joiner caches?
When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows. After building the caches, the Joiner transformation reads records from the detail source and perform joins.
-
What r the join types in joiner transformation?
Normal (Default) Master outer Detail outer Full outer
-
what r the settiings that u use to cofigure the joiner transformation?
Master and detail source Type of join Condition of the join
-
What r the diffrence between joiner transformation and source qualifier transformation?
U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. U need matching keys to join two relational sources in source qualifier transformation.Where as u doesn’t need matching keys to join two sources. Two relational sources should come from same datasource in sourcequalifier.U can join relatinal sources which r coming from diffrent...
-
What is aggregate cache in aggregator transforamtion?
The aggregator stores data in the aggregate cache until it completes aggregate calculations.When u run a session that uses an aggregator transformation,the informatica server creates index and data caches in memory to process the transformation.If the informatica server requires more space,it stores overflow values in cache files.
-
What r the mapping paramaters and maping variables?
Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session. When u use the maping parameter ,U declare and use the parameter in a maping or maplet.Then define the value of parameter in a parameter file for the session. Unlike a mapping parameter,a maping variable represents a value that can change...
-
What r the unsupported repository objects for a mapplet?
COBOL source definition Joiner transformations Normalizer transformations Non reusable sequence generator transformations. Pre or post session stored procedures Target defintions Power mart 3.5 style Look Up functions XML source definitions IBM MQ source defintions
-
What r the methods for creating reusable transforamtions?
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...
-
What r the reusable transforamtions?
Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances...
-
What r the active and passive transforamtions?
An active transforamtion can change the number of rows that pass through it.A passive transformation does not change the number of rows that pass through it.
-
what is a transforamation?
It is a repostitory object that generates,modifies or passes data.
-
What is the maplet?
Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.
-
-
Why we use lookup transformations?
Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks:Get a related value-Get the Employee Name from Employee table based on the Employee IDPerform Calculation.Update slowly changing dimension tables - We can use unconnected lookup transformation to determine whether the records already exist...
-
What is a Source Qualifier?
It represents all data queried from the source.
-
What is Router transformation?
Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.
-
What are various types of Aggregation?
Various types of aggregation are SUM, AVG, COUNT, MAX, MIN, FIRST, LAST, MEDIAN, PERCENTILE, STDDEV, and VARIANCE.
-
What are Aggregate transformation?
Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.
-
How do you reference a Parameter?
In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER Parameter name
-
What is a Schema ?
The set of objects owned by user account is called the schema.
-
What are Stored procedures?
A stored procedure ia s named collection of SQL statements and procedural logic that is compiled, verified and stored in a server database. It is typically treated like any other database object. Stored procedures accept input parameters so that a single procedure can be used over the network by multiple clients using different input data. A single remote message triggers the execution of a collection...
-
Differentiate between TRUNCATE and DELETE
TRUNCATE deletes much faster than DELETETRUNCATEDELETEIt is a DDL statementIt is a DML statementIt is a one way trip,cannot ROLLBACKOne can RollbackDoesn't have selective features (where clause)HasDoesn't fire database triggersDoesIt requires disabling of referential constraints.Does not require
-
What is a OUTER JOIN?
Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition.
-
-
-
-
-
-
-
What is OLAP?
Answer posted by Vikas R on 2005-05-22 02:57:09: OLAP stands for Online Analytical Processing. It is used for Anaytical reporting
-
-
-
-
-
How do we call shell scripts from informatica?
Answer posted by Staline on 2005-05-27 00:42:44: You can use a Command task to call the shell scripts, in the following ways: 1. Standalone Command task. You can use a Command task anywhere in the workflow or worklet to run shell commands. 2. Pre- and post-session shell command. You can call a Command task as the pre- or post-session shell command for a Session task. For more information...
-
What are active transformation / Passive transformations?
Answered by kiran on 2005-05-08 09:32:14: An active transformation can change the number of rows as output after a transformation, while a passive transformation does not change the number of rows and passes through the same number of rows that was given to it as input.
-
What is the difference between Power Center & Power Mart?
Answered by kiran on 2005-05-08 09:27:46: Power Mart is designed for: Low range of warehouses only for local repositories mainly desktop environment. Power mart is designed for: High-end warehouses Global as well as local repositories ERP support.
-
-
Differences between star and snowflake schemas
Answered by sudhakar on 2005-05-09 18:32:18: star schema uses denormalized dimension tables,but in case of snowflake schema it uses normalized dimensions to avoid redundancy...
-
What is VLDB
Answered by Kiran on 2005-05-06 20:12:19: The perception of what constitutes a VLDB continues to grow. A one terabyte database would normally be considered to be a VLDB.
-
-
What type of Indexing mechanism do we need to use for a typical datawarehouse
Answered by on 2005-03-23 01:45:54: bitmap index
-
-
-
What are the various Reporting tools in the Market
Answered by Hemakumar on 2005-04-12 05:40:50: Cognos BusinessObjects MicroStrategies Actuate
-
-
What is ETL
ETL is extraction,transformation and loading,ETL technology is used for extraction the information from the source database and loading it to the target database with the necessary transformations done in between.
-
What Snow Flake Schema
Answered by Girinath.S.V.S on 2005-03-17 06:40:48: Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. For example, a product dimension table in a star schema might be normalized into a products table, a product_category table, and a product_manufacturer table in a snowflake schema. While this...
-
-
What is a Star Schema
Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)
-
What is ER Diagram
Answered by Puneet on 2005-05-07 04:21:07: ER - Stands for entitity relationship diagrams. It is the first step in the design of data model which will later lead to a physical database design of possible a OLTP or OLAP database
-
What are Data Marts
Data Mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes complete individual data warehouses which are usually smaller than the corporate data warehouse.
-
What is a Data Warehousing?
Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much easier and more efficient to run queries over data that originally came from different sources. Typical relational databases are designed for on-line transactional processing (OLTP) and do not meet the...