Explore topic-wise InterviewSolutions in Current Affairs.

WHETHER it is:
1. 1:1
2. 1:m
3. m:m
1:M

whether it is:
1. 1:1
2. 1:m
3. m:m
1:M

► Operational DATA Store has very low data LATENCY. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart.
► ODS is more closer to OLTP system. We don't normally prefer to store AGGREGATED data in OLTP. So it is with ODS.
► UNLIKE data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps CHANGING.

► Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart.
► ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.
► Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.

We can TUNE the REPORT by USING INDEX awareness in universe.

We can tune the report by using index awareness in universe.

Auditor is used by the business OBJECTS administrators to know the complete information of the business intelligence SYSTEM.
► it monitors entire BIsystem at a glance.
► ANALYZES usage and CHANGE impact
► optimises the BI deployment

Auditor is used by the business objects administrators to know the complete information of the business intelligence system.
► it monitors entire BIsystem at a glance.
► Analyzes usage and change impact
► optimises the BI deployment

A MANAGEMENT REPORTING TOOL to gauge how well the ORGANIZATION COMPANY is performing. It normally uses "traffic-lights" or "smiley faces" to determine the status.

A management reporting tool to gauge how well the organization company is performing. It normally uses "traffic-lights" or "smiley faces" to determine the status.

You can format the BO Reports by using various features available. You can turn the table reports into a 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a DIFFERENT format , based on some business rule. You can also create some prompts, which will ASKS user to give some input values before SEEING the reports, this way they will SEE only filtered data. There are many similar exciting options available to enhance the reports.

You can format the BO Reports by using various features available. You can turn the table reports into a 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a different format , based on some business rule. You can also create some prompts, which will asks user to give some input values before seeing the reports, this way they will see only filtered data. There are many similar exciting options available to enhance the reports.

Some of the standard BUSINESS INTELLIGENCE tools in the market ACCORDING to their performance
► MICROSTRATEGY
► BUSINESS OBJECTS,CRYSTAL REPORTS
► COGNOS REPORT NET
► MS-OLAP SERVICES
Or
► SEAGATE Crystal report
► SAS
► Business objects
► Microstrategy
► Cognos
► Microsoft OLAP
Hyperion
Microsoft integrated services.

Some of the standard Business Intelligence tools in the market According to their performance
► MICROSTRATEGY
► BUSINESS OBJECTS,CRYSTAL REPORTS
► COGNOS REPORT NET
► MS-OLAP SERVICES
Or
► Seagate Crystal report
► SAS
► Business objects
► Microstrategy
► Cognos
► Microsoft OLAP
Hyperion
Microsoft integrated services.

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 software
development and maintenance of the PeopleSoft? Applications and consultation to CUSTOMERS with their
computer-related TASKS.

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 software
development and maintenance of the PeopleSoft? Applications and consultation to customers with their
computer-related tasks.

It DEPENDS UPON the Database limits provided to DEFINE the Foreign key constraint, e.g. in Sql Server 2005, the recommended max LIMIT for foreign keys is 253, but you can define more.

It depends upon the Database limits provided to define the Foreign key constraint, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more.

OLAP - On-Line Analytical Processing.
Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.

MOLAP - Multidimensional OLAP.
This term designates a cartesian data structure more specifically. In effect, MOLAP contrasts with ROLAP. Inb the FORMER, JOINS between tables are already suitable, which enhances performances. In the latter, joins are computed during the request.
Targeted at groups of users because it's a shared environment. Data is stored in an exclusive server-based format. It performs more complex analysis of data.

DOLAP - Desktop OLAP.
Small OLAP products for local multidimensional analysis Desktop OLAP. There can be a mini multidimensional database (using Personal Express), or extraction of a datacube (using BUSINESS Objects).
Designed for low-end, single, DEPARTMENTAL user. Data is stored in cubes on the desktop. It's like having your own spreadsheet. Since the data is local, end users dont have to worry about performance hits against the server.

ROLAP - Relational OLAP.
Designates one or several star SCHEMAS stored in relational databases. This technology permits multidimensional analysis with data stored in relational databases.
Used for large departments or groups because it supports large amounts of data and users.

HOLAP:Hybridization of OLAP, which can include any of the above.

OLAP - On-Line Analytical Processing.
Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.

MOLAP - Multidimensional OLAP.
This term designates a cartesian data structure more specifically. In effect, MOLAP contrasts with ROLAP. Inb the former, joins between tables are already suitable, which enhances performances. In the latter, joins are computed during the request.
Targeted at groups of users because it's a shared environment. Data is stored in an exclusive server-based format. It performs more complex analysis of data.

DOLAP - Desktop OLAP.
Small OLAP products for local multidimensional analysis Desktop OLAP. There can be a mini multidimensional database (using Personal Express), or extraction of a datacube (using Business Objects).
Designed for low-end, single, departmental user. Data is stored in cubes on the desktop. It's like having your own spreadsheet. Since the data is local, end users dont have to worry about performance hits against the server.

ROLAP - Relational OLAP.
Designates one or several star schemas stored in relational databases. This technology permits multidimensional analysis with data stored in relational databases.
Used for large departments or groups because it supports large amounts of data and users.

HOLAP:Hybridization of OLAP, which can include any of the above.

► Business Objects Reporter
► Reporting & Analyzing tool
► Designer
► Universe creation
► database interaction
► connectivity
Supervisor - For Administrative PURPOSES
Webintelligence - Access of report data through INTERNET
BroadCast Agent - For scheduling the REPORTS
Data Integrator - The ETL tool of Business Objects, DESIGNED to handle huge amounts of data.

► Business Objects Reporter
► Reporting & Analyzing tool
► Designer
► Universe creation
► database interaction
► connectivity
Supervisor - For Administrative purposes
Webintelligence - Access of report data through internet
BroadCast Agent - For scheduling the reports
Data Integrator - The ETL tool of Business Objects, designed to handle huge amounts of data.

Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable USERS to analyze DIFFERENT dimensions of multidimensional data. For example, it provides time series and trend analysis views. The CHIEF component of OLAP is the OLAP SERVER, which SITS between a client and a database management systems (DBMS). The OLAP server understands how data is organized in the database and has special functions analyzing the data.

A good OLAP interface has writes an efficient sql and reads an accurate data from db.To design and architect having good knowledge on DB understanding the report requirements.

Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. The chief component of OLAP is the OLAP server, which sits between a client and a database management systems (DBMS). The OLAP server understands how data is organized in the database and has special functions analyzing the data.

A good OLAP interface has writes an efficient sql and reads an accurate data from db.To design and architect having good knowledge on DB understanding the report requirements.

"universe" is a "Business OBJECT" terminology. Business objects also happens to be the name of the COMPANY. The universe is the interfacing layer between the client and the datawarehouse . The universe defines the relationship among the various TABLES in the datawarehouse.

Or

Universe is a semantic layer between the DATABASE and the user interface (REPORTS).

"universe" is a "Business object" terminology. Business objects also happens to be the name of the company. The universe is the interfacing layer between the client and the datawarehouse . The universe defines the relationship among the various tables in the datawarehouse.

Or

Universe is a semantic layer between the database and the user interface (reports).

In ReprotNet have TWO vertions
1.ReportNet 1.0
2.ReportNet 1.1 MR1, MR2.

In ReprotNet have two vertions
1.ReportNet 1.0
2.ReportNet 1.1 MR1, MR2.

CREATE a Query Subject, from the properties PANE select externalise,there we have 4 options in that select IQD.

Create a Query Subject, from the properties pane select externalise,there we have 4 options in that select IQD.

It has six (6) FORMATS in report net. They are HTML, PDF, EXCEL 2000, Excel 2002, CSV, and XML format. We can see the types of formats in the report viewer on the right side .

It has six (6) formats in report net. They are HTML, PDF, Excel 2000, Excel 2002, CSV, and XML format. We can see the types of formats in the report viewer on the right side .

If we wanna test the report in report net, first we can intially check by validating it in the report PAGE.

After that we can test the out PUT of the report Using a sql anlyser and sql query.so here we will be comparing the sql ANALYZER output with the output of the report viewer.

If we wanna test the report in report net, first we can intially check by validating it in the report page.

After that we can test the out put of the report Using a sql anlyser and sql query.so here we will be comparing the sql analyzer output with the output of the report viewer.

Yes it can connect MULTIPLE datasources at a time when the FRAME work MANAGER has the metta DATA regarding that datasources.

Yes it can connect multiple datasources at a time when the frame work manager has the metta data regarding that datasources.

The difference between FILTER and Condition:Condition returns true or false Ex: if Country = 'India' then ...Filter will return two types of results1.Detail information which is equal to where clause in SQL statement2.Summary information which is equal to Group by and Having clause in SQL STATEMENT.

The difference between Filter and Condition:Condition returns true or false Ex: if Country = 'India' then ...Filter will return two types of results1.Detail information which is equal to where clause in SQL statement2.Summary information which is equal to Group by and Having clause in SQL statement.

Prompts is mean by the end user can be filter the DATA.
1.you can open the explore bar and added the new prompts PAGE, And enter the new name.
2. you go to TOOL MENU and track prompts button
3. you select prompts and then ok.

Prompts is mean by the end user can be filter the data.
1.you can open the explore bar and added the new prompts page, And enter the new name.
2. you go to tool menu and track prompts button
3. you select prompts and then ok.

procedure for providing SECURITY for query subject in frame WORK MANAGER is:
select querysubject -> in properties pane select ->security filters(CLICK on edit)a specify data security wizard appears->click on add groups -> cognosnamesspace(select users and groups wizard opens)

procedure for providing security for query subject in frame work manager is:
select querysubject -> in properties pane select ->security filters(click on edit)a specify data security wizard appears->click on add groups -> cognosnamesspace(select users and groups wizard opens)

ReportNet has a three-tier architecture, namely,
(1) Web server (2) Applications and (3) Data.
The tiers are based on business function, and are typically SEPARATED by FIREWALLS. ReportNet user INTERFACES sit above the tiers.ReportNet user interfaces include
(a) Web-based Cognos Connection, Cognos Report Studio, and Query Studio
(b) Windows-based Framework Manager.

ReportNet has a three-tier architecture, namely,
(1) Web server (2) Applications and (3) Data.
The tiers are based on business function, and are typically separated by firewalls. ReportNet user interfaces sit above the tiers.ReportNet user interfaces include
(a) Web-based Cognos Connection, Cognos Report Studio, and Query Studio
(b) Windows-based Framework Manager.

Componenets of Report Studio:
1. Insertable Objects pane.
2. Properties pane.
3. Explorer bar - Conditional Explorer, QUERY Explorer, Page Explorer.
4. Report VIEWER - Workarea, Report Layout Objects.

Componenets of Report Studio:
1. Insertable Objects pane.
2. Properties pane.
3. Explorer bar - Conditional Explorer, Query Explorer, Page Explorer.
4. Report Viewer - Workarea, Report Layout Objects.

Query Studio:
1. Used to create Ad-hoc (or) simple reports.
2. It does not PROVIDE any pre-defined report templates.
3. It directly displays data (WITHOUT RUNNING the report) when we insert attributes in the report.

Report Studio:
1. Used to create complex reports.
2. It provides pre-defined report templates.
3. It does not DISPLAY the data directly in the report. We need to run the report to display the data.

Query Studio:
1. Used to create Ad-hoc (or) simple reports.
2. It does not provide any pre-defined report templates.
3. It directly displays data (without running the report) when we insert attributes in the report.

Report Studio:
1. Used to create complex reports.
2. It provides pre-defined report templates.
3. It does not display the data directly in the report. We need to run the report to display the data.

PROMPTS act as questions that help users to customize the information in a REPORT to suit their own needs.The DIFFERENT types of Prompt are
Value prompt
Text Prompt
Date prompt
Time prompt
Date and time prompt
Using prompts is faster and easier than repeatedly changing the filter.

Cognos Report Studio provides several ways to create prompts. You can
• use the Build Prompt Page tool
• build your own prompt and prompt page
• create a PARAMETER to produce a prompt
• create a Prompt directly in a report page.

Prompts act as questions that help users to customize the information in a report to suit their own needs.The different types of Prompt are
Value prompt
Text Prompt
Date prompt
Time prompt
Date and time prompt
Using prompts is faster and easier than repeatedly changing the filter.

Cognos Report Studio provides several ways to create prompts. You can
• use the Build Prompt Page tool
• build your own prompt and prompt page
• create a parameter to produce a prompt
• create a Prompt directly in a report page.

Setting up drill-through access from PowerPlay Web to ReportNet INVOLVES

1. configuring COGNOS Series 7 for drill-through access to ReportNet
2. preparing the Transformer model and cube
3. copying the search path of the folder that contains the target report
4. enabling the cube for drill-through access to ReportNet
5. deciding which FILTERS to create in the target report
6. creating the target report
7. disabling the Drill Through Assistant.

Setting up drill-through access from PowerPlay Web to ReportNet involves

1. configuring Cognos Series 7 for drill-through access to ReportNet
2. preparing the Transformer model and cube
3. copying the search path of the folder that contains the target report
4. enabling the cube for drill-through access to ReportNet
5. deciding which filters to create in the target report
6. creating the target report
7. disabling the Drill Through Assistant.

There is a lot of difference between Crystal reports an COGNOS REPORT net.

1.Crystal report is a product of Business Objects where as Reportnet is of cognos.

2.Cryatal reports is for only low 2 MIDRANGE analysis and that to some EVEN says tha they wont use this for analysis used to make proper strategic decision But report net yes it is for high END analysis.

3.In reportnet we can login through web and can create our own desired report through web.

There is a lot of difference between Crystal reports an Cognos Report net.

1.Crystal report is a product of Business Objects where as Reportnet is of cognos.

2.Cryatal reports is for only low 2 midrange analysis and that to some even says tha they wont use this for analysis used to make proper strategic decision But report net yes it is for high end analysis.

3.In reportnet we can login through web and can create our own desired report through web.

In COGNOS reportnet
Native SQL is used for the single datasource to import the meta DATA
Cognos SQL used for MULTIPLE DATASOURCES to import the METADATA.

In cognos reportnet
Native SQL is used for the single datasource to import the meta data
Cognos SQL used for multiple datasources to import the metadata.

ONE of the advantage's of Reportnet, is
It is web-based reporting wherein, REPORTS can be easily accessed from anywhere through a BROWSER. by using ipromptu we can use multidimensional analysis to SEE the data in diff formates.i.e we have drillup,DRILLDOWN features in cognos impromtu,but it is not possible in reportnet.

One of the advantage's of Reportnet, is
It is web-based reporting wherein, reports can be easily accessed from anywhere through a browser. by using ipromptu we can use multidimensional analysis to see the data in diff formates.i.e we have drillup,drilldown features in cognos impromtu,but it is not possible in reportnet.

JAVA TRANSFORMATION available in the 8x VERSION and it is not available in 7X version.

Java Transformation available in the 8x version and it is not available in 7x version.

Pros: LOADING, SORTING, Merging OPERATIONS will be faster as there is no index concept and Data will be in ASCII mode.

Cons: There is no concept of updating existing records in flat FILE.

As there is no indexes, while LOOKUPS speed will be lesser.

Pros: Loading, Sorting, Merging operations will be faster as there is no index concept and Data will be in ASCII mode.

Cons: There is no concept of updating existing records in flat file.

As there is no indexes, while lookups speed will be lesser.

PMCMD>startworkflow -F foldername workflowname

pmcmd>startworkflow -f foldername workflowname

There R 3 TYPES of DIMENSIONS
1.star SCHEMA
2.snowflake schema
3.glaxy schema

There r 3 types of dimensions
1.star schema
2.snowflake schema
3.glaxy schema

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 tools access. The informatica client and server access the repository to save and retrieve metadata.

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 tools access. The informatica client and server access the repository to save and retrieve metadata.

PC Repository is a relational DATABASE that STORES the METADATA describes different OBJECTS like mapping and transformation. This is managed by repository SERVICE.

PC Repository is a relational database that stores the metadata describes different objects like mapping and transformation. This is managed by repository service.

Difference between static and dynamic CACHE
Static- Once the data is CACHED , it will not change. example unconnected lookup uses static cache.
Dynamic- The cache is UPDATED as to reflect the update in the table( or source) for which it is reffering to.(ex. connected lookup).

Difference between static and dynamic cache
Static- Once the data is cached , it will not change. example unconnected lookup uses static cache.
Dynamic- The cache is updated as to reflect the update in the table( or source) for which it is reffering to.(ex. connected lookup).

while IMPORTING flat file DEFINETION just specify the scale for a neumaric data type. in the mapping, the flat file source supports only NUMBER datatype(no decimal and integer). In the SQ ASSOCIATED with that source will have a data type as decimal for that number PORT of the source.

source ->number datatype port ->SQ -> decimal datatype.Integer is not supported. hence decimal is taken care.

while importing flat file definetion just specify the scale for a neumaric data type. in the mapping, the flat file source supports only number datatype(no decimal and integer). In the SQ associated with that source will have a data type as decimal for that number port of the source.

source ->number datatype port ->SQ -> decimal datatype.Integer is not supported. hence decimal is taken care.

Its a session option. when the informatica server PERFORMS INCREMENTAL aggr. it passes new source data through the mapping and uses historical chache data to PERFORM new aggregation caluculations incrementaly. for performance we will USE it.

Its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it.

NORMALIZER: It is a transormation MAINLY using for COBOL sources,
it's change the rows into coloums and columns into rows
NORMALIZATION:To REMOVE the retundancy and inconsitecy.

Normalizer: It is a transormation mainly using for cobol sources,
it's change the rows into coloums and columns into rows
Normalization:To remove the retundancy and inconsitecy.

Let me TELL you that one can start the sessions in this WAY in the CASE of sequential batches only. In case of the concurrent batches it is virtually impossible.

Let me tell you that one can start the sessions in this way in the case of sequential batches only. In case of the concurrent batches it is virtually impossible.

In the Type2 mapping we have THREE OPTIONS to recognize the newly added rows Version number Flag VALUE, EFFECTIVE date Range.

In the Type2 mapping we have three options to recognize the newly added rows Version number Flag value, Effective date Range.

TWO options
RUN the session only if previous session COMPLETES SUCCESSFULLY.
Always runs the session.

Two options
Run the session only if previous session completes successfully.
Always runs the session.

PMCMD is USED to START a BATCH.

pmcmd is used to start a batch.

If one of SESSION is configured to “run if PREVIOUS COMPLETES” and that previous session FAILS.

If one of session is configured to “run if previous completes” and that previous session fails.

Any NUMBER of SESSIONS.

Any number of sessions.

NO

NO

Configure the session to partition SOURCE data.
INSTALL the INFORMATICA server on a MACHINE with multiple CPU’s.

Configure the session to partition source data.
Install the Informatica server on a machine with multiple CPU’s.

PARTITIONING ACHIEVES the session performance by REDUCING the time period of reading the SOURCE and LOADING the data into target.

Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target.

Mapping PARAMETERS are parameters which are constant through out the SESSION. They are SPECIFIED before running the session. Unlike parameters, variables change through out the session.

Mapping parameters are parameters which are constant through out the session. They are specified before running the session. Unlike parameters, variables change through out the session.

We need matching KEYS in source qualifier which we do not need in JOINER TRANSFORMATION.

We need matching keys in source qualifier which we do not need in joiner transformation.