Hi there

   Teradata utilities are :

1)Mloads

2)Fast Export

3)BTEQ

4)TPump

5).fast load

Hi there

   Teradata utilities are :

1)Mloads

2)Fast Export

3)BTEQ

4)TPump

Active Data Warehouse is the DWH that enables the decision makers of the organisation to understand the trends and patterns of the market (by analysing the captured transactional data in the DWH) and thereby helping them to arrive at an INFORMED future decision(s).

Thanks.

Alpesh

Active Data Warehousing (ADW)The technical ability to capture transactions when they change, and integrate them in to the warehouse - along with maintaining batch or scheduled cycle refreshes.

ranking has priority than sorting .we apply ranking on dimension based on the measure like if you want to display top 100 sales revenue generated by a product or bottom 100 sales generated by a product.sorting is not based on measure or anything it will sort in
ascending ,descending or custom order

If we think logically what is the purpose of sorting, if its been ranked already, Ranking will sort the rows from higher to lowest order(Descending order).  Does it make sense :)



Thanks
Rex

Go to help and click About Designer in help, you will find it.

1. Select the component business object Designer
2. Now it will prompt for userid/password/security domain
3. You will find a Help button, click that and find out what ever you want

Cheers

Sithu

Variable Ports usually carry intermediate data (values) and can be used in Expression transformation.

variable port is used to break the complex expression into simpler

and also it is used to store intermediate values

In Star schema, the data in the dimensional table is denormalized where as data in the Snow flake schema, it is normalized

In any schema fact table is in normalized form . it has reference keys to reference dimensional tables. Hence it is normalized

hierarchy is an ordered series of related dimension objects grouped together to perform the multidimensional analysis.
Multidimensional analysis is  a technique to modify the data,so that the data  can be viewed from  different perspectives and at different levels

A related group of dimentions grouped together to perform multi dimentional analysis is known as Hierarchy.

Why not just use an inline select statement in your sql qualifier to eliminat the overhead of a lookup transformation all together?

Connected and Unconnected lookups have their own pros and cons.Unconnected lookup is designed for a specific purpose.The task that an unconnected lookup does can be done by a connected lookup also. Th...

Informatica Server Object is must.

Cheers,

Sithu

Informatica server must run,,

use following
expression in update strategy transformation.
iif ( condition 1 , DD_INSERT,
  condition 2 , DD_UPDATE,
  condition 3 , DD_DELETE,
  DD_REJECT -- for default)

and set session property as data driven, You can cross check these conditions values during session debug runs.

In general DWH scenario, we create TABLE_REJECT or FILE_REJECT to keep a check of the rejected records. For all the updates happening we keep timestamp or some other flag in the database.Before t...

if both the tables are relational we can join both the tables using sql override but if one table is relational and another table is a flat then we've to use joiner transformation.

if both the tables are available in same database by using source qualifier we can join i.e by using customized source qualifier
if the tables are available in different database by using lookup we can join i.e one is source table and other is lookup table

When you create a version of a folder referenced by shortcuts, all shortcuts continue to reference their original object in the original version. They do not automatically update to the current folder...

Hi manoj,

I appreciate ur response ,But can u be a bit clear

thanks

sri

Informatica Metadata Exchange (MX) provides a set of relational views that allow easy SQL access to the Informatica metadata repository. The Repository Manager generates these views when you create or...

Hi Ravi ,

If possible please elaborate on Informatica SuperGlue.

Regards

Punu

Validation Strategies Data validation strategies are often heavily influenced by the architecture for the application. If the application is already in production it will be significantly harder to bu...

Two universes can be link Dynamically by using "Link Parameter".

In join is a relational operator, It can connect between two column. In universal join to merge two universe between same column

Context is basically used when we will have conformed dimension in the loop........

context is nothing but specifying the name of the path

the place where u cannot resolve the loops with allias there comes concept of context


alias is nothing but the duplicate name of some other table

Designing a normalized schema is known as data modeling


Designing a de-normalized schema is known as dimension modeling

Data Modelling is  designing of the data content and structure of the database. The data model documents the structure of and interrelationships between the data - it is presented as a combinatio...

ETL TOOL (eg:Informatica, Data stage, Abinitio..) is for EXTRACTING data from a source systems(a system where client's transactional business information resides) and performing business logic(applyi...

ETL tool is used for Extration ,Transformation(filtering) and loading the data into data warehouse .


OLAP tools are used to analitical purpose basically for report generation i.e to retrieve the data from dataware,OLAP is multidimensional model.

1. Smart Matching columns
2. Manually you can link

Cheers,

Sithu

ODS is nothing but operational data source. It contains  most recent data .it contains around 30-60 days data  It is placed in between source system and staging area..   reports can also be taken in ODS .

Operational Data Store (ODS): An ODS is an integrated database of operational data. Its sources include legacy systems and it contains current or near term data. An ODS may contain 30 to 60 days of information, while a data warehouse typically contains years of data.
it is before staging

Main Diff Bet 5.1 & 6.5v - Cluster Concept:In BO 6.5v architecture ClusterManager & Cluster Nodes are there. "Cluster" means group of Cluster Nodes."Cluster Manager" means group of C...

Hi Sithu,I am looking at the PDF document "businessobjects_xi_whats_new.pdf" (goto Page 10) downloaded from the BusinessObjects site. A sample info found on this pdf:----------------------------------...

BO repository is a set of relational data structures stored on a database. It is the heart of business objects. I t can also be called central management server.repository contains reports of BO.

There is no concept or Domains from XI R2. Everything will be viewed as metadata though all these information is stored in the database tables.

Domain concept ends with the 6x only.

Thanks.

There are following types of dimensional tables: 1.Slowly changind dimensions(SCD) a)SCD-1:stores only current values b)SCD-2:stores both previous and current values c)SCD-3:stores cu...

The Dimensions are Confirmed Dimension, Junk/Dirty Dimension, Degenerated Dimension and Slowly Changing Dimensions(SCD)-(Under slowly changing dimensions we have 6 types, they are Type1, Type2, Type3, Type4, Type5 and Type6).

You can use the Expression transformation to calculate values in a single row before you write to the target. For example, you might need to adjust employee salaries, concatenate first and last names, or convert strings to numbers.

Expression finds the Primary key is or not, and calculates new flag

Based on that New Flag, filter transformation filters the Data

Cheers,

Sithu

Surrogate key is a numeric or integer value in a table to identify each row uniquely. Primary key and surrogate key are same but surrogate key is a system generated value has a define incremental valu...

Surrogate key and primary key both are same, but point of application is different. Primary key is part of transactional system but surrogate key is part of analytical system. Surrogate key is used...

Hi All,

Could you please let me know what is Replicate Cube & Transparent Cube?

Thanks & regards,

Amit Sagpariya

Hi All,

Could you please let me know what is Replicate cube &

Lets you set the user identification and properties for the administrator of the Broadcast Agent. Broadcast Agent is a BusinessObjects product that handles the scheduled or batch processing of documen...

broadcast agent is used for scheduling or bursting the reports.thru this,you can schedule your reports so that end-users can access reports thru internet.you have broadcast administration console here...

Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table

Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.

Run a stored procedure before or after your session.Unconnected Run a stored procedure once during your mapping, such as pre- or post-session.Unconnected Run a stored procedure every time a ...

Unconnected:The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another t...

Top-Down approach means first create the datawarehouse for entire organization then divide it into for each specific
subject are called datamarts
Bottom-Up approach means first create the data marts then by combining all data marts create the datawarehouse

Top Down-------------To build an mammoth enterprise data warehouse iteratively considering all enterprise needs and then feed individual departmental data marts.Bottom Up------------To build ...

The update transformation/strategy uses the concept of keys, in order to update the target table. As flat file do not have any Keys defined on it, it is not possible to update the target,. which is a flat file.

You can modify the flat file using shell scripting in unix ( awk, grep, sed ).

Hope this helps.

to copy a table along with records

 create table  as
 select *from ;


if we want to copy only structure
 
 create  table < new tablename>
 select *from  where ;

Yes , we can copy the table structure. create table as select * from where 1=2;

Drill up means up in the hierarchy.
Month:-Quarter:-Year

Drill down means down in the hierarchy
Year:-Quarter:-Month

Drill through means you can drill through to the database directly from drill mode and get the required data

Drill by means you can select one hierarchy to another hierarchy

Drill up : UP-one level

Drill down: DOWN-one level

Drill by : selection of level Hierarchy

Drill trough : Hirearchy to another Hirearchy

Cheers,

Sithu

User It is just an account name for the user Owns a schema Have the same name Create user command, create the user User can be considered schema User can created without schema It is the account for t...

Diff b.w OLTP and OLAP :------------------------OLTP Schema  :* Normalized * More no.of trans* Less time for queries execution* More no.of users* Have Insert,delete and update trans. OLAP (D...

In simple words,

An OLTP system is used to get data into the system.

A datawarehouse system is used to get data out of the system.

-Ritu

data ware house is summarized,subject oriented,non volatile,historic, time invarient (only insertion's no updations) , denormalized. one, which support OLAP process.where as database support's detail...

OLAP--- Using the online entered data is used for analytical processing.

Data warehouse is the place where the data will pulled and kept in one place which will not change frequently and is also used for analytical processsing.

A data warehouse is a database geared towards the business intelligence requirements of an organisation. The data warehouse integrates data from the various operational systems and is typically loaded...

OLAP is a concept of analyzing the data present in datawarehouse.  i.e. the data should be in denormalized form,integrated,non-volatile,time varient.  Then we can make use OLAP better.

for better decision making process and to increase the profitability of business.

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

DWh is (6 important points about DWH) :

1. Dedicated Data Base
2. Integrated Data
3. Subject Oriented
4. Time Variant
5. Nonvolatile
6. Decision Support

Idan Halfon

Okay there are two camps on this Bill Inmon which is Date and Coddbased database design that has grown into the ODS reporting DSS database and of course Ralph Kimball whose mythology comprises of a st...

Stored Procedure is a re-usable program which is created once and reused n times .
It stores the procedure at database level
It provides security, better performance.

Stored Procedure is an already written sql statements that is saved in database.

Universe Design as follows:
Define Parameters -> Insert Database Schema (tables, columns..etc)->Make the Joins->Resolve the loops->create classes and Objects->Hierarchies.

Then test the universe for integraty.

Cheers,
Ravi Kumar Garre
ravi_kumar_garre@yahoo.co.in

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

Designer

1. It is one of the business objects components
2. It is used to create universes
3. It is used to define measures/metrics
4. It is used to do the calculations

Sithu

Its a mapping of business requirements with the database structures in the database.

Designer lets you save universes in either enterprise or workgroup mode.Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working withou...

Insert a user object

1 Select the User Objects command from the Insert menu.
The Insert User Objects dialog box is displayed.
2 Click a user object file.
A user object file has a .udo extension
3 Click the Open button.

Cheers,

Sithu

this holds the logical arrangement of facts/diemensions and mesures

Cheers,

Sithu

An universe is an symanteic layer between the user and the Designer which contains connection of a database

Universe is a Semantice layer that maps the data structure found in databases (tables, columns, views..etc) to Business Terms.

Cheers,
Ravi Kumar Garre
ravi_kumar_garre@yahoo.co.in

A component with in a class that groups the object

Cheers,

Sithu

Insert tables in the Structure pane1 Select the Tables command from the Insert menu.2 In the Table Browser, click the tables you want to add to the universe structure.To select several conti...

A strategy is a script that automatically extracts structural information from a database. Designer provides a number of default strategies you can use. These are strategies for extracting joins, dete...

external

The secured connections are used to access universe or document. It can be used by several users.

Cheers,

Sithu

The secured connections are used to access universe or document that may be restricted or confidential

Cheers,

Sithu

If you click the File/New starts Quick Design wizard check box in the General tab (Tools menu, Options command) the New command automatically launches the Quick Design wizard.

Cheers,

Sithu

the values what exactly the user need is query

Cheers,

Sithu

The qualification of an object reveals how it can be used in multidimensional analysis. An object can be qualified as a dimension, a detail, or a measure. In the Universe window, the symbol besid...

Personal connections are used to access resources such as universe or document

Cheers,

Sithu

The designer can design the universe in offline mode for that you need to login at least once

Cheers,

Sithu

An object derived from aggregate function, that is know as mesure object

Cheers,

Sithu

A loop is a situation that occurs when more than one path exists from one table to another. Loops result in ambiguity in the design of a universe.

 Designer enables you to identify loops in one of two ways:

alies

Contexts

Cheers,

Sithu

Loop is a logical and pictorial representation of tables joined in such a way that the join's path begin and end with the same table.

Usually such a table would return less number of rows and it is usually the intersection condition values.

Loops are resolved by Alias Table.

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

Relational operation that causes two tables

Cheers,

Sithu

Hierarchy is an arrangement of objects for report to report interactions [RRI]. It is used for drill-down and drill-up operations in universe design.

a series of dimensions used for analysis based on user requierments

Cheers,

Sithu

Within BusinessObjects enterprise, user names can be authenticated against one of more security databases. The default authentication source is Enterprise. However, if your company uses Windows NT, for example then NT user name and password can be used to log into Designer.


Cheers,
Ravi Kumar Garre

Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository. The mode in which you save your universe determines whether other designers are able to access them.

Cheers,

Sithu

The area of the repository that stores documents, templates, scripts, and lists of values.

all the document informations are stored here,

Cheers,

Sithu

A dimension is an object that is a focus of analysis in a query. A dimension maps to one or more columns or functions in the database that are key to a query. For example Country, Sales Person, Products, or Sales Line.

A Dimension object is typically textual information by which users analyze the numeric measures, such as product, region, or month. A dimension object often comes from the lookup or reference tables w...

Context :   defined as a group of joins shares common business purpose                    ...

Context:

Contexts are a collection of joins which provide a valid query path for Web

Intelligence to generate SQL.

Regards,
Siva

BO Designer supports three different types of connections, each denoted with a unique symbol in the list of connections:1. Personnal connections that users may create for freehand SQL or that universe...

A connection is a set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and the path to the database.

Cheers,

Sithu

Lets you create a condition. The conditions that you define appear within the Universe window. From the Query Panel, a user can drag the conditions from the Classes and Objects box to the Conditions box.

Cheers

Sithu

A Category is grouping of certain entities [reporting objects]. A class is a category of reporting objects. A object is an instance of class or a reporting field [entity]. A class can be further divid...

Classes are folders that serve to organize data objects according to common business need. A class can contain any type of object, including another class, (i.e. subclass). The number of classes and s...

Table A having m records and Table B having n records then the cartesian prodcut is mXn.

Regards,
Ravi Kumar Garre
ravi_kumar_garre@yahoo.co.in

Cartesan product is the result of a query when the two tables are not joined by any type of join. All the possible combinations of one table are displayed with the other table just like a cartesan product in algebra

Cardinality describes a join between 2 tables by stating how many rows of one table will match with rows of another table. It is very important to detect join problems and to create the contexts to co...

Cardinality means "How many instances of an Entity (on one side of the join) are related to the how many instance of another entity (on the other side of the join)"

An alias is identical to base table with different name. The data in alias is exactly same as original table/but the different name tricks SQL into accepting that we are using 2 different tables. ...

Actually, What happens in the back end (i.e) in database end, while alias is performed, whether it points to one table or too many table. How the performance will be in universe level.

Please help me by explaining with this concept correctly, because i faced such question by interviewer.

Non additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.

A fact that cannot be logically added between records, such as average, and that must be combined in a computation with other facts before being added across records.

Ans  A) is correct

Each Foreign Key must exist as a Primary Key.
Foreign Keys can change values over time.

Cheers.

Sithu

The utilities are in teradata as follows

Bteq for loadind/Unloading the data

Fload for load the data only one table at a time it must be empty

mload for load the data which is empty or populated table up to 5 tables at a time

fexport to export the data

tpump to load the data upto 64 tables

Both statements are TRUE

ODS (Operational Data sources) or Datamarts

ODS=>Operational Data Source

Cheers,

Sithu

An ER Diagram.  It shows the relationship of tables to each other.

Entity-Relationship diagram

Sysnonym can be used for the user who created it. But alias can be used for any users. Synonym is dropped when base table got dropped but alias will not get dropped.  Synonym is recorded in the sys.synonym table and alias is recorded in sys.tables.

An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.

Cheers,

Sithu

DDL - Data Definition Language - Used to create/alter/delete Database objects
DML- Data Manipulation Language - Used to insert/delete/update/select the data in the database obects(table/views...)

DDL(data definition language)DDL Statement are  ·          Create·          Alter and·   &...

You can work with remote,

But you have to

Configure FTP

Connection details

IP address

User authentication

Cheers

Sithu

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

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

It is an RDBMS.
It keeps metadata. (information about tha data)
It keeps only logical informatoin. No physical data inside the repository.

Infromatica Repository:The informatica repository is at the center of the informatica suite. You create a set of metadata tables within the repository database that the informatica application and too...

Mapplet is a group of reusable transformation.The main purpose of using Mapplet is  to hide the logic from end user point of view...It works like a function in C language.We can use it N number of times.Its a reusable object.
Reusable transformation is a single transformation.

Maplet: one or more transformations

Reusable transformation: only one transformation

Cheers,

Sithu

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

Yes.

Yes. It is Possible through Metadata Reporter

Type2

1. Version number

2. Flag

3.Date

Cheers,

Sithu

1. Simple Pass through2. Slowly Growing TargetCheers,Sithu

Inf designer :Mapping ->  wizards -->  1) Getting started -->Simple pass through mapping               &nb...

Simple Pass through

Slowly Growing Target

Slowly Changing the Dimension

Type1

Most recent values

Type2

Full History

Version

Flag

Date

 Type3

Current and one previous

When Data driven option is selected in session properties it the code will consider the update strategy (DD_UPDATE,DD_INSERT,DD_DELETE,DD_REJECT) used in the mapping and not the options selected in the session properties.

The Informatica Server follows instructions coded into Update Strategy transformations within the session mapping to determine how to flag rows for insert, delete, update, or reject. If the mapping fo...

Update strategy transformation is used for flagging the records for insert, update, delete and reject In Informatica power center u can develop update strategy at two levels use update strategy T/...

The model you choose constitutes your update strategy, how to handle changes to existing rows. In PowerCenter and PowerMart, you set your update strategy at two different levels: Within a session. Whe...

When you join related tables in one Source Qualifier transformation, the Integration Service joins the tables based on the related keys in each table. This default join is an inner equijoin, using the...

Default join is Normal Join/Inner Join/Equi-Join

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

It is a transformation which is automatically generated to read the data from source tables into informatica designer.

Source Qualifier is a transformation with every source definiton if the source is Relational Database.Source Qualifier fires a Select  statement on the source db.With every Source Definition...

can you give me a real time scenario please?

we use a stored procedure transformation to execute a stored procedure which in turn might do the above things in a database and more.

A Router transformation has the following types of groups: Input Output Input Group The Designer copies property information from the input ports of the input group to create a set of output ports for...

Input group contains the data which is coming from the source.We can create as many user-defined groups as required for each condition we want to specify.Default group contains all the rows of data that doesn't satisfy the condition of any group. 

Note:- i think the definition and purpose of Router transformation define by sithusithu, sithu is not clear and not fully correct as they of have mentioned <A Router transformation tests data for o...

A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. A Filter transformation tests data for one condition and drops the...

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

Cheers,

Sithu

The Normalizer transformation normalizes records from COBOL and relational sources, allowing you to organize the data according to your own needs. A Normalizer transformation can appear anywhere in a ...

There are 2 important caches. 1. Static : By default integration service chooses statyic cache.It is read only cache . when you first query the lookup table, it caches the table. whenever a row com...

Caches are of following types:
1. Static Cache
2. Dynamic Cache
3. Persistent Cache
4. Non-persistent Cache
5. Shared Cache
6. Un-shared Cache

More types to follow...:-)

hey, what zaki told was correct.

There are only two type: connected and unconnected.

Mostly we use cache concept for connected, also only connected lkp will support SOME cache options.

hello boss/madam

only two types of lookup are there they are:
1) Connected lookup
2) Unconnected lookup.

I don't understand why people are specifying the cache types, I want to know that now a days caches are also taken into this category of lookup.
If yes do specify on the answer list

thankyou

Lookup transformation in a mapping is used to look up data in a flat file or a relational table, view, or synonym. You can import a lookup definition from any flat file or relational database to which...

Use a Lookup transformation in your mapping to look up data in a relational table, view, or synonym. Import a lookup definition from any relational database to which both the Informatica Client and Server can connect. You can use multiple Lookup transformations in a mapping.

Cheers,

Sithu

For version 7.x and above :When the PowerCenter Server processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The...

Specifies the directory used to cache master records and the index to these records. By default, the cached files are created in a directory specified by the server variable $PMCacheDir. If you overri...

There are 4 Types of Joiner Trasnformations: 1) Normal 2) Master Outer 3) Detail Outer 4) Full Outer Note: A normal or master outer join performs faster than a full outer or detail o...

follw thisIn the Mapping Designer, choose Transformation-Create. Select the Joiner transformation. Enter a name, click OK. The naming convention for Joiner transformations is JNR_TransformationName. E...

There are number of properties that you use to configure a joiner transformation are: 1) CASE SENSITIVE STRING COMPARISON: To join the string based on the case sensitive basis. 2) WORKING DIRECT...

the Joiner transformation supports the following join types, which you set in the Properties tab:

• Normal (Default)
• Master Outer
• Detail Outer
• Full Outer

Cheers,

Sithu

source qualifier is used for reading the data from the database where as joiner transformation is used for joining two data tables.source qualifier can also be used to join two tables but the conditio...

hi, as per my knowledge, you need matching keys to join two relational sources both in Source qualifier as well as in Joiner transformation. But the difference is that in Source qualifier, both the keys must have primary key - foreign key relation, Whereas in Joiner transformation its not needed.

when  server runs the session with aggregate transformation ,it stores data in memory until it completes the aggregation when u partition a source ,the server creates one memory cache and one disk ca...

Aggregate cache contains data values while aggregate calculations are being performed. Aggregate cache is made up of index cache and data cache. Index cache contains group values and data cache consists of row values.

Mapping parameter represents a constant value defined before mapping run.

Mapping reusability can be achieved by using mapping parameters.



Mapping variable represents a value that can be changed during the mapping run.

Mapping variable can be used in incremental loading process.

You can use mapping parameters and variables in the SQL query, user-defined join, and source filter of a Source Qualifier transformation. You can also use the system variable $$$SessStartTime. The Inf...

1)Stored procedure preload or postload is not possible.
2)Dont allow the not reusable sequence generator.
3)xml source qualifier
4)Normalizer
5)Nested mapplets

−Normalizer transformations
−Cobol sources
−XML Source Qualifier transformations
−XML sources
−Target definitions
−Pre- and post- session stored procedures
−Other mapplets
-PowerMart 3.5-style LOOKUP functions
-non reusable sequence generator

You can design using 2 methods

1. using transformation developer
2. create normal one and promote it to reusable

Cheers

Sithu

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

1. A reusable transformation can be used in multiple transformations2.The designer stores each reusable transformation as metada separate from   any mappings  that use the transformatio...

Hai to all friends out therethe transformation that can be reused is called a reusable transformation.as the property suggests it has to be reused:so for reusing we can do it in two different ways 1) ...

Thats not correct. By this definition Update Strategy should be a passive transformation but it is not.

So correct answer is that any transformation which can change 1. Number of rows 2. Row type i.e. DD_INSERT, DD_DELETE... 3. Transaction control... All these are active ones.

Passive Transformation: When the number of input records to a transformation is equal to the number of output records from the transformation then we call that transformation as Passive Transformation...

A TransFormation Is a Repository Object.
That Generates,Modifies or Passes Data.
The Designer Provides a Set of Transformations That perform Specific Functions.
For Example An AGGREGATOR Transformation Performs Calculations On Groups Of Data.

Transformation is a repository object of converting a given input to desired output.It can generates,modifies and passes the data.

Basically mapplet is a subset of the mapping in which we can have the information of the each dimension keys by keeping the different mappings created individually. If we want a series of dimension keys in the final fact table we will use mapping designer.

A mapplet is a reusable object that represents a set of transformations. Mapplet can be designed using mapping designer in informatica power center

Normalizer transformaiton which is used to normalize the data

sirajdeen

Normalizer transformation.
Normalizer transformation which is used to normalize the data.Since COBOL sources are often consists of De-normalized data.

Thats a good question, suppose say you have 40 transformations in your mapping which invole complex agg, functions,  so in middle of the mapping there is a requirement to get the data from some  x t...

Look up tranformations are used to
Get a related value
Updating slowly changing dimension
Caluculating expressions

1. Source Qualifier is the most important transformation which convert the source data type in to compatible NATIVE datatype of a mapping.2. Without a SQ a mapping can not be created, after extractio...

Source Qualifier is one of the transformations, which converts any type of data to the relational format. So that, can easily be used for any of the operations on the data.

Router transformation can be said as an extension of filter transformation. Filter allows you to check for a single condition and rejects rows which does not meet the condition.But Router transformati...

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.

Sum, Count, Average, Median

• AVG
• COUNT
• FIRST
• LAST
• MAX
• MEDIAN
• MIN
• PERCENTILE
• STDDEV
• SUM
• VARIANCE

Cheers,

Sithu

1. Aggrigator transformation allows to perform aggrigate calculation, such as SUM, MAX, MIN, FIRST, LAST
2. Aggrigator transformation allows to perform aggrigate calculation of group.

To perform Group by calculations  we use Aggregator Transformation.It perform calculations similar to Expression Transformation.But difference  between both is that Aggregator Transform...

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

Schema is a set of objects own by a Particular user..

Schema is collection of database object.

A stored procedure is a precompiled collection of Transact-SQL statements and optional flow control statements, similar to an executable script. Stored procedures are stored and run within the databas...

DELETE is a DML command so it works on row level, where TRUNCATE is a DDL command, so it works on object level, TRUNCATE actually deletes the table and recreates it, so whatever people say that it works faster or frees occupied space or high water mark or oil mark.The actual internal work was that.

One main freature is when we have used auto increment clause the would return to next value after delete statement. e.g: if id =1000
then after delete statement when we insert any record the value will be 1001 but if we use truncate statement then auto increment value will come to 0 positon

OUTER JOIN is the way to collect records in case of lack of true join condition.

outer join is that type of jon which retrives the matach & alson unmatached recores also from the tables

When there are duplicate keys in either or all of the joined datasets the result is a cartesion product. This is termed as Cartesian Join in Abinitio.Eg:If there are two input datasets for a join func...

 join two tables without join key , that is crossproduct.

The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for softw...

BroadCast Agent Service is used for scheduling & Monitoring the Documents.

Middle layer of the data base table to Reporting tool

Universe is a Semantic Model or you can Layer which helps to connect users to different databases to design module for business requirement. Universe is a methodology to modify the structure of data...

2 Types
Web Based: CMC,Infoview,Polestar,CCM
Window Based:UNIV,Webrich,BVM,Zcelsius

The various modules in BO are .,

Desktop Intelligence, Designer module, Import wizard which are in client side.

Web Intelligence(Infoview), Central Management Console (CMC), Central Management Server (CMS), Perfomance Management (PM) are in server side. 

BO, Crystalreports, Xcelsius

Micro Startegy
Microsoft OLAP
Qlik view
Informatica
BO
SAS
Crystal Report
Xcelsius

 OLAP(ONLINE ANALYTICAL PROCESSING):It is a set of specifications which allows the client applications in retriving the data from the DataWareHouse for analytical process.There r 4 types of OLAPS...

 OLAP – Online analytical Processes MOLAP – Multidimensional Online analytical Processes (Cubes) ROLAP – Relational Online analytical Processes (RDBMS) HOLAP – Combination of MOLAP...

olap stands for Online Analytical Processing.
Every day we load OLTP to OLAP for Data analysis.
Then generate reports base this reports end-user take decisions.

OLAP is used to extract data from multiple sources. All extraction is done online by making use of ETL

Decision making data

BI is refers to computer-based techniques used in identifying extracting and analyzing business data ,such as sales revenue by products and/or departments, or by associated costs and income and also...

1. Normally ETL Tool stands for Extraction Transformation Loader

2. This helps you to extract the data from different ODS/Database,

3. If you have a requirement like this you need to get the ETL tools, else you no need any ETL

Cheers,

Sithu

ETL Tools are meant to extract, transform and load the data into Data Warehouse for decision making. Before the evolution of ETL Tools, the above mentioned ETL process was done manually by using SQL c...

Parameter files are used for static variable exectuion of a task. this file can b modifies/updated for later change in the parameter. say for ex, xyz="RAJAT" is defined in the parameter file...

You can pass a parameter value to a task using a file, Mostly it will be used in dynamic value assignment

Sithu

SIMPLY to say::::::::::::::::::

worklet : set of sessions

mapplet : set of transformations that can be called within a mapping

mapping :-set of transformations.And moving data from source to target along with transformation s

session :-set of instructions source addresses and target address u write it

worklet:- set of sessions

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

Hi,There are two ways to do this,they are as follows:1)we can use a command task anywhere  in the workflow or worklet to run the shell commands.2)In the session task,we can call reusable command ...

Conditional statements are also given in the Expression transformation then why it is passive transformation....

Active transformation is nothing but it will change the no of rows passing through it (example) Filter transformation .In it when  we have 1000 rows as input after filter transformation according...

Informatica PowerCenter - Has all options, including distributed metadata, ability to organize repositories into a data mart domain and share metadata accross repositories, Partioning is available. In...

Power Center is designed for:

High-end Warehouses

Global as well as local repositories

Power Mart is designed for:

Low-end Warehouses

Only for local repositories

9.5

9.1.0 is the latest version of PowerCenter.

star schema uses denormalized dimension tables,but in case of snowflake schema it uses normalized dimensions to avoid redundancy...

Star Schema                                &n...

Very Large Database (VLDB)

it is sometimes used to describe databases occupying magnetic storage in the terabyte range and containing billions of table rows. Typically, these are decision support systems or transaction processing applications serving large numbers of users.

Cheers,

Sithu

VLDB stands for Very Large Data Base, any database too large (normally more than 1TB) cosidered as VLDB.

Non Additive facts cannot be aggregrated along with dimenstion in the fact table. For eg. Age, weather

Non additive facts are the facts that do not participate in arithmetic caliculations. for example in stock fact table there will be opening and closing balances along with qty sold and amt etc. but opening and closing balances were never used in arithmetic calculations.

Hash Index - If we know that the hashing will result in uniform distribution and doesn't create hotspots (spikes-chaining).Bitmap Index - If the degree of cardinality is high for the attribute, me...

Space requirements for indexes in a warehouse are often significantly larger than the space needed to store the data, especially for the fact table and particularly if the indexes are B*trees.Hence, y...

The Real time data warehouse is really a combination of real time (Current) and historical data warehouse.In real time world the historical systems are less valuables because of issues facing managers...

Real time Data warehousing means combination of hetrogenious databases and query and analysis purpose and Decisionmaking and reporting purpose.

There is one more data modelling tool available in the market and that is "KALIDO".
This is end to end data warehousing tool. Its a unique and user friendly tool.

Rational Rose

One tool is also missing in the list. i.e. Dundas Chart for .NET OLAP Services

IntelliView

INEA

MS-Excel

Business Objects (Crystal Reports)

Cognos (Impromptu, Power Play)

Microstrategy

MS reporting services

Informatica Power Analyzer

Hyperion (BRIO)

Oracle Express OLAP

Proclarity

SAS

Qlikview

Actuate

jasper reports

1. Oracle Warehouse Builder (OWB) 11gR1 Oracle 2. Data Services XI 3.2 SAP Business Objects 3. IBM Information Server (Datastage) 9.1 IBM 4. SAS Data Integration Studio 4.21 SAS Institute 5. Pow...

ODI is the future of all ETL tools..because its E-LT not ETL.

ETL is a process that extracts data from one database, transforms it as per the destination database and loads it into another database. In the transformation process, data is actually standardized to...

Data Acquisition technique is now called ETL(Extraction, Transformation and Loading)Extraction-The process of extracting the data from various sources. Sources can be file system, database, XML file, ...

Snow-flake schema is a logical arrangement of tables in dimensional modeling where a centralized fact table references number of other dimension tables; however, those dimension tables are further nor...

Closely related to the star schema, the snowflake schema is represented by centralized fact tables which are connected to multiple dimensionsIn the snowflake schema, however, dimensions are normalized...

Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two types of tables - Facts table and Dimen...

Dimension modelling is a logical design technique that seeks to present the data in a standard framework that allows users for high performance accesss.

star schema defined as,A fact table is surrounded my many multiple dimension tables.
(it means all dimension tables directly maintains relationship with the fact tables in this schema)

star schema (also called star-join schema, data cube, or multi-dimensional schema) is the simplest style of data warehouse schema. The star schema consists of one or more fact tables referencing any n...

The ER Diagrams is the initial process to analaysis a database application, and understands the problems related or causes in future with the choosed database application, in this satge different comp...

Entity Relationship Diagrams are a major data modelling tool and will help organize the data in your project into entities and define the relationships There are three basic elements in ER models: Ent...

Data Marts: Data Mart is a subset of Data Warehousing. Depending upon the management decision the warehouse devides into smaller part according to their respective subject. eg sales is a data mart of xyz warehouse

Datamart is a subset of datwarehouse. Data mart deals with single line of business like Sales, Purchase etc. Size of data will be less when compared to Datawarehouse.
Some of the different types of datamart are Depndant datamart , Independant datamart, Hybrid datamart

Hi..!! As explained following above different people have different definitions for a data warehouse. The most popular definition came from Bill Inmon, who provided following: A data warehouse is a su...

Data warehouse is Subject oriented,Integrated Non volatile, Time variant collection of data. unlike transactional systems. Its a Denormalized huge database.Used for Querying and Reporting Analytics.