Explore topic-wise InterviewSolutions in Current Affairs.

A UNIVERSE connects the client to the DATA warehouse. It is a FILE defining relationships AMONGST the tables in the warehouse, CLASSES and objects, database connection details.

A universe connects the client to the data warehouse. It is a file defining relationships amongst the tables in the warehouse, classes and objects, database connection details.

BUSINESS objects in business intelligence are entities of the business. COGNOS MAKES BI and performance planning SOFTWARE.

Business objects in business intelligence are entities of the business. COGNOS makes BI and performance planning software.

A business OBJECT can be USED to represent ENTITIES of the business that are SUPPORTED in the design. A business object can accommodate data and the BEHAVIOR of the business associated with the entity.

A business object can be used to represent entities of the business that are supported in the design. A business object can accommodate data and the behavior of the business associated with the entity.

Aggregate awareness is a term that DESCRIBES the ability of a universe to make use of aggregate tables in a database. These are tables that contain precalculated data. You can use a function called @Aggregate_Aware in the Select statement for an object that directs a query to be RUN against aggregate tables rather than a table containing non aggregated data.
Pros:
SPEED up the execution of query and Improve the PERFORMANCE of Sql transaction.
If you are using the aggregate tables then you must refresh the aggregate table with all fact tables to have the consistency in your result.

Aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database. These are tables that contain precalculated data. You can use a function called @Aggregate_Aware in the Select statement for an object that directs a query to be run against aggregate tables rather than a table containing non aggregated data.
Pros:
Speed up the execution of query and Improve the performance of Sql transaction.
If you are using the aggregate tables then you must refresh the aggregate table with all fact tables to have the consistency in your result.

RIGHT click on any object,go to the properties.specify the QUERY in SELECT and put the next query in where clause,
LIKE select COLNAME from TABNAME1 where COLNAME IN(select colname2 from tab2)

Right click on any object,go to the properties.specify the query in select and put the next query in where clause,
like select COLNAME from TABNAME1 where COLNAME IN(select colname2 from tab2)

INDEX AWARENESS is the ability to take advantage of the indexes on KEY columns to speed DATA retrieval.

Index awareness is the ability to take advantage of the indexes on key columns to speed data retrieval.

In DESIGNER Level
1)eliminate the unnecessory JOINS
2)USE conditions as much as at the database level
3)edit the SQL query in the Query Panel as per requirment

In REPORTER level
1)eliminate the FILTERS as much as possible
2)try to reduce the user variables.

In DESIGNER Level
1)eliminate the unnecessory joins
2)use conditions as much as at the database level
3)edit the SQL query in the Query Panel as per requirment

In REPORTER level
1)eliminate the filters as much as possible
2)try to reduce the user variables.

Select the COMPONENT business OBJECT Designer
Now it will PROMPT for userid/password/security domain
You will find a Help BUTTON, click that and find out what ever you want

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

ELECT @@VERSION is the command that will give the SAID DETAILS.

elect @@version is the command that will give the said details.

Slice & Dice is FACILITY in BO. we can enables change the POSITIONS of data in REPORT..here in Bo we slice & dice panel by USING this we can CREATE cross tables and masterdetails tables.

Slice & Dice is facility in BO. we can enables change the positions of data in Report..here in Bo we slice & dice panel by using this we can create cross tables and masterdetails tables.

pragma pack PREPROCESSOR dirictive specifies the BYTE boundary for packing MEMBERS of c structures.syntax: #pragma pack(N)

pragma pack preprocessor dirictive specifies the byte boundary for packing members of c structures.syntax: #pragma pack(n)

Using QUICK DESIGN WIZARD for developing the universe will INVOKE the built-in strategy.

Using quick design wizard for developing the universe will invoke the built-in strategy.

GUIDELINES are PROVIDED in the Universe guide:
Here is the Summary:
1) Modify the array fetch size in SBO FILE
2) Assign table weights and change the default order of the tables in a query by changing parameter in PRM file
3) Use shorcut joins to avoid unnecessary tables that may come in Query
4) Use aggregated tables.

Guidelines are provided in the Universe guide:
Here is the Summary:
1) Modify the array fetch size in SBO file
2) Assign table weights and change the default order of the tables in a query by changing parameter in PRM file
3) Use shorcut joins to avoid unnecessary tables that may come in Query
4) Use aggregated tables.

We can set the predefined condition in the universe level. In the task BAR of the DESIGNER there is an icon for filtering. Just click on the icon. It ASKS for the condition name. After giving the name for the condition TYPE the SQL for that condition. finally submit the sql.

We can set the predefined condition in the universe level. In the task bar of the designer there is an icon for filtering. Just click on the icon. It asks for the condition name. After giving the name for the condition type the sql for that condition. finally submit the sql.

Creating a filter in designer is different from creatind a filter in BUSINESS object
if u create a filter in designer it can acessible to all the REPORTS UR r using i'e,it can used for further applications where as creatin a filter vin business object is DYNAMIC(run time) it will applicable to only tht particular report.

Creating a filter in designer is different from creatind a filter in business object
if u create a filter in designer it can acessible to all the reports ur r using i'e,it can used for further applications where as creatin a filter vin business object is dynamic(run time) it will applicable to only tht particular report.

To create context :

goto Tools --> Detect Loops, BO will detect loops if there are any & will suggest the context candidate (something LIKE Sales, COSTS that is related to that specific SUBJECT area)

Select the suggested candidate & click on create Context. It will map all those joins that are required for say Sales subject area & PUT it in Sales Context. same with Costs.

So it will avoid the confilcts in path by using Contexts.

This Auto DETECTION works in most of the times....but not always.

To create context :

goto Tools --> Detect Loops, BO will detect loops if there are any & will suggest the context candidate (something like Sales, Costs that is related to that specific subject area)

Select the suggested candidate & click on create Context. It will map all those joins that are required for say Sales subject area & put it in Sales Context. same with Costs.

So it will avoid the confilcts in path by using Contexts.

This Auto Detection works in most of the times....but not always.

We have securities in BUSINESS objects
LIKE
1.Windows authentication
2.RDBMS securities
3.supervisor LEVEL securities, IE User name/ password.

We have securities in business objects
Like
1.Windows authentication
2.RDBMS securities
3.supervisor level securities, ie User name/ password.

Business Objects DEALS with databases, for EVERY universe you need to SPECIFY a database connection. flat files dont have the database format so you'll need to convert them into some database. to do that, you will need to write a procedure which will read data from flat files & relate it according to surrogate KEYS, then using that procedure POPULATE the database & then use that database for the source of the universe.

using flat files ONLY , you can not create universe. because there is nothing as database connection available for flat file.

Business Objects deals with databases, for every universe you need to specify a database connection. flat files dont have the database format so you'll need to convert them into some database. to do that, you will need to write a procedure which will read data from flat files & relate it according to surrogate keys, then using that procedure populate the database & then use that database for the source of the universe.

using flat files ONLY , you can not create universe. because there is nothing as database connection available for flat file.

If your database CONSIST all dates something like 01/02/2000 or 01-Feb-2000, you will need to break the date FIELD into year, QTR,MONTH & if required date.
to do this, create a class named TIME, under that create new object, in it's select box use oracle's date functions to get required information.

For E.g. : to_char(sales_date, 'YYYY') for getting only year from the date.
similarly, for quarter you can use to_char(sales_date, 'Q')
& for month to_char(sales_date, 'MM') for month number, instead of 'MM' if you use 'MON' it will return you abrevations like Jan for January & so on. for full name of month use 'MONTH'.

If your database consist all dates something like 01/02/2000 or 01-Feb-2000, you will need to break the date field into year, qtr,month & if required date.
to do this, create a class named TIME, under that create new object, in it's select box use oracle's date functions to get required information.

For E.g. : to_char(sales_date, 'YYYY') for getting only year from the date.
similarly, for quarter you can use to_char(sales_date, 'Q')
& for month to_char(sales_date, 'MM') for month number, instead of 'MM' if you use 'MON' it will return you abrevations like Jan for January & so on. for full name of month use 'MONTH'.

MEASURE OBJECTS are the objects which have facts i.e all $ amounts
a dimension object cannot be CALCULATED with another dim object.
in order to have a seperate identity for $ amounts we DEFINE as measure objects.
just create an object for ex:revenue then right clicck on the object or double click on the object n then change the property of that object to measure its that SIMPLE.

Measure objects are the objects which have facts i.e all $ amounts
a dimension object cannot be calculated with another dim object.
in order to have a seperate identity for $ amounts we define as measure objects.
just create an object for ex:revenue then right clicck on the object or double click on the object n then change the property of that object to measure its that simple.

At-least ONE OBJECT in the CLASS must be PRESENT in the other class so that they can have a JOIN n afcourse the datatypes.

At-least one object in the class must be present in the other class so that they can have a join n afcourse the datatypes.

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 the second phase, you can proceed to enhance the components of your universe. You can also prepare certain objects for multidimensional analysis. As with the first phase, you should test the integrity of your universe structure. You may also WISH to PERFORM tests on the universes you create from the BusinessObjects User MODULE. Finally, you can distribute your universes to users by EXPORTING them to the repository or via your file system.

For a universe based on a simple relational schema, Designer provides Quick Design, a wizard for creating a basic yet complete universe. You can use the resulting universe immediately, or you can modify the objects and create complex new ones. In this way, you can gradually refine the quality and structure of your 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 the second phase, you can proceed to enhance the components of your universe. You can also prepare certain objects for multidimensional analysis. As with the first phase, you should test the integrity of your universe structure. You may also wish to perform tests on the universes you create from the BusinessObjects User module. Finally, you can distribute your universes to users by exporting them to the repository or via your file system.

For a universe based on a simple relational schema, Designer provides Quick Design, a wizard for creating a basic yet complete universe. You can use the resulting universe immediately, or you can modify the objects and create complex new ones. In this way, you can gradually refine the quality and structure of your universe.

Dependency analysis will ANSWER the QUESTIONS regarding datalinage.That is where does the data come from,what applications prodeuce and depend on this data etc.

We can retrieve the MAXIMUM (surrogate key) from the existing data,the by using scan or next_ in_ sequence/ reformat we can generate further sequence for new RECORDS.

Dependency analysis will answer the questions regarding datalinage.That is where does the data come from,what applications prodeuce and depend on this data etc.

We can retrieve the maximum (surrogate key) from the existing data,the by using scan or next_ in_ sequence/ reformat we can generate further sequence for new records.

Because implicit is USING for internal PROCESSING and explicit is using for user open data requied.

Because implicit is using for internal processing and explicit is using for user open data requied.

Basically,This is a part of D.B.A responsibilities GRANT means permissions for EXAMPLE GRANT CREATE TABLE ,CREATE VIEW AND MANY MORE .

REVOKE means CANCEL the grant (permissions).So,Grant or Revoke both commands depend upon D.B.A.

Basically,This is a part of D.B.A responsibilities GRANT means permissions for example GRANT CREATE TABLE ,CREATE VIEW AND MANY MORE .

REVOKE means cancel the grant (permissions).So,Grant or Revoke both commands depend upon D.B.A.

By using ROLLUP we CANT GENERATE cumulative summary records for that we will be using scan.

By using rollup we cant generate cumulative summary records for that we will be using scan.

Because EVERY JOB depend upon another job for example if you first job RESULT is successfull then another job will execute OTHERWISE your job doesn't work.

Because every job depend upon another job for example if you first job result is successfull then another job will execute otherwise your job doesn't work.

Do you MEAN by merging Gui map files in WR.If so, by merging GUI map files in GUI map editor it wont create corresponding TEST script.without testscript you cant RUN a file.So it is impossible to run a file by merging 2 GUI map files.

Do you mean by merging Gui map files in WR.If so, by merging GUI map files in GUI map editor it wont create corresponding test script.without testscript you cant run a file.So it is impossible to run a file by merging 2 GUI map files.

EXPLAIN PLAN can be REVIEWED to CHECK the execution plan of the query. This would guide if the expected INDEXES are used or not.

Explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not.

If you are TRYING to install the AB -Initio on stand ALONE machine , then it is not necessary to create the REPOSITORY , While INSTALLING It creates automatically for you under abinitio folder ( where you installing the Ab-Initio) If you are still not clear please ask your Question on the same portal .

If you are trying to install the Ab -Initio on stand alone machine , then it is not necessary to create the repository , While installing It creates automatically for you under abinitio folder ( where you installing the Ab-Initio) If you are still not clear please ask your Question on the same portal .

Truncate :
It is a DDL COMMAND, used to delete TABLES or clusters. Since it is a DDL command hence it is auto commit and Rollback can't be performed. It is faster than delete.

Delete:
It is DML command, GENERALLY used to delete a record, clusters or tables. Rollback command can be performed , in order to retrieve the earlier deleted things. To make deleted things PERMANENTLY, "commit" command should be used.

Truncate :
It is a DDL command, used to delete tables or clusters. Since it is a DDL command hence it is auto commit and Rollback can't be performed. It is faster than delete.

Delete:
It is DML command, generally used to delete a record, clusters or tables. Rollback command can be performed , in order to retrieve the earlier deleted things. To make deleted things permanently, "commit" command should be used.

There are several ways to do this:
1) We can MOVE the table in the same or other TABLESPACE and rebuild all the indexes on the table.
alter table move this activity reclaims the defragmented SPACE in the table
analyze table table_name compute statistics to capture the updated statistics.
2)Reorg could be DONE by TAKING a dump of the table, truncate the table and import the dump back into the table.

There are several ways to do this:
1) We can move the table in the same or other tablespace and rebuild all the indexes on the table.
alter table move this activity reclaims the defragmented space in the table
analyze table table_name compute statistics to capture the updated statistics.
2)Reorg could be done by taking a dump of the table, truncate the table and import the dump back into the table.

USE HINTS /*+ */, these ACTS as DIRECTIVES to the OPTIMIZER.

Use hints /*+ */, these acts as directives to the optimizer.

The oracle engine uses WORK areas for internal PROCESSING in order to the execute sql STATEMENT is called cursor.There are two types of CURSORS like Implecit cursor and Explicit cursor.Implicit cursor is using for internal processing and Explicit cursor is using for user open for data required.

The oracle engine uses work areas for internal processing in order to the execute sql statement is called cursor.There are two types of cursors like Implecit cursor and Explicit cursor.Implicit cursor is using for internal processing and Explicit cursor is using for user open for data required.

RECOMPILE is useful when the tables referenced by the stored proc UNDERGOES a lot of modification/ deletion/ addition of data. Due to the heavy modification activity the execute plan becomes OUTDATED and HENCE the stored proc performance goes down. If we create the stored proc with recompile option, the sql server WONT cache a plan for this stored proc and it will be recompiled every time it is run.

Recompile is useful when the tables referenced by the stored proc undergoes a lot of modification/ deletion/ addition of data. Due to the heavy modification activity the execute plan becomes outdated and hence the stored proc performance goes down. If we create the stored proc with recompile option, the sql server wont cache a plan for this stored proc and it will be recompiled every time it is run.

MAIN Purpose of Stored Procedure for reduse the NETWORK trafic and all SQL statement executing in cursor so SPEED too HIGH.

Main Purpose of Stored Procedure for reduse the network trafic and all sql statement executing in cursor so speed too high.

A CARTESIAN JOIN will GET you a Cartesian product. A Cartesian join is when you join every row of one table to every row of another table. You can ALSO get one by joining every row of a table to every row of itself.

A Cartesian join will get you a Cartesian product. A Cartesian join is when you join every row of one table to every row of another table. You can also get one by joining every row of a table to every row of itself.

An OUTER JOIN is used when one wants to SELECT all the records from a PORT - whether it has satisfied the join CRITERIA or not.

An outer join is used when one wants to select all the records from a port - whether it has satisfied the join criteria or not.

In RDBMS the relationship between the two tables is REPRESENTED as PRIMARY key and foreign key relationship. Wheras the primary key table is the parent table and foreignkey table is the child table.The CRITERIA for both the tables is there should be a matching column.

In RDBMS the relationship between the two tables is represented as Primary key and foreign key relationship. Wheras the primary key table is the parent table and foreignkey table is the child table.The criteria for both the tables is there should be a matching column.

If the user wants to group the records on particular FIELD values then rollup is best way to do that. Rollup is a multi-stage transform function and it contains the following mandatory functions.
1. initialise
2. rollup
3. finalise
Also need to declare one temporary variable if you want to GET counts of a particular group.

For each of the group, first it does call the initialise function once, followed by rollup function CALLS for each of the records in the group and FINALLY calls the finalise function once at the end of last rollup call.

If the user wants to group the records on particular field values then rollup is best way to do that. Rollup is a multi-stage transform function and it contains the following mandatory functions.
1. initialise
2. rollup
3. finalise
Also need to declare one temporary variable if you want to get counts of a particular group.

For each of the group, first it does call the initialise function once, followed by rollup function calls for each of the records in the group and finally calls the finalise function once at the end of last rollup call.

To CONVERT 4 way to 8 way partition we need to CHANGE the layout in the partioning component. There will be seperate parameters for each and every type of partioning eg. AI_MFS_HOME, AI_MFS_MEDIUM_HOME, AI_MFS_WIDE_HOME ETC.

The APPROPRIATE parameter need to be SELECTED in the component layout for the type of partioning.

To convert 4 way to 8 way partition we need to change the layout in the partioning component. There will be seperate parameters for each and every type of partioning eg. AI_MFS_HOME, AI_MFS_MEDIUM_HOME, AI_MFS_WIDE_HOME etc.

The appropriate parameter need to be selected in the component layout for the type of partioning.

ablocal_expr is a parameter of itable component of Ab Initio.ABLOCAL() is replaced by the contents of ablocal_expr.Which we can make USE in parallel unloads.There are TWO forms of AB_LOCAL() construct, one with no arguments and one with single ARGUMENT as a table name(driving table).

The use of AB_LOCAL() construct is in Some COMPLEX SQL statements contain grammar that is not recognized by the Ab Initio parser when unloading in parallel. You can use the ABLOCAL() construct in this case to prevent the Input Table component from parsing the SQL (it will get passed through to the DATABASE). It also specifies which table to use for the parallel clause.

ablocal_expr is a parameter of itable component of Ab Initio.ABLOCAL() is replaced by the contents of ablocal_expr.Which we can make use in parallel unloads.There are two forms of AB_LOCAL() construct, one with no arguments and one with single argument as a table name(driving table).

The use of AB_LOCAL() construct is in Some complex SQL statements contain grammar that is not recognized by the Ab Initio parser when unloading in parallel. You can use the ABLOCAL() construct in this case to prevent the Input Table component from parsing the SQL (it will get passed through to the database). It also specifies which table to use for the parallel clause.

The LATEST VERSION of GDE ism1.15 AND Co>OPERATING system is 2.14.

The latest version of GDE ism1.15 AND Co>operating system is 2.14.

You can USE $mpjret in endscript like
if 0 -EQ($mpjret)
then
ECHO "success"
else
mailx -s "[graphname] FAILED" mailid

You can use $mpjret in endscript like
if 0 -eq($mpjret)
then
echo "success"
else
mailx -s "[graphname] failed" mailid

ChalapathiFirst we can CHECK the PROPERTIES in INTERNET options and then you can check in cmd format telenet ABINITIO ip_add.

ChalapathiFirst we can check the properties in internet options and then you can check in cmd format telenet abinitio ip_add.

The MAIN difference b/w dml & xfr is that
DML represent FORMAT of the metadata.
XFR represent the tranform functions.which will contain BUSINESS rules

The main difference b/w dml & xfr is that
DML represent format of the metadata.
XFR represent the tranform functions.which will contain business rules

Maxcore is a value (it will be in KB).Whne ever a COMPONENT is EXECUTED it will take that MUCH memeory we SPECIFIED for execution.

Maxcore is a value (it will be in Kb).Whne ever a component is executed it will take that much memeory we specified for execution.

The GENARAL SYNTAX is "m_dump METADATA DATA [ACTION] "

The genaral syntax is "m_dump metadata data [action] "

Here is a simple EXAMPLE to use a start script in a graph:
In start script lets give as:
export $DT=`date '+%m%d%y'`
Now this variable DT will have today's date before the graph is RUN.
Now somewhere in the graph TRANSFORM we can use this variable as;
out.process_dt::$DT;
which provides the VALUE from the SHELL.

Here is a simple example to use a start script in a graph:
In start script lets give as:
export $DT=`date '+%m%d%y'`
Now this variable DT will have today's date before the graph is run.
Now somewhere in the graph transform we can use this variable as;
out.process_dt::$DT;
which provides the value from the shell.

1.10 is a non key VERSION and REST are key versions.

There are LOT of components ADDED and REVISED at following versions.

1.10 is a non key version and rest are key versions.

There are lot of components added and revised at following versions.