Generaly, we test the simple list report with sql queries..

Otherwise, we generate the report and sent to the chambian 
user, to validate.

rgds,
-palz-

Import Wizard used to migrate the reports/ users/ universe 
connection etc etc.
Report Conversion Tool(RCT) is used to convert the DeskI 
reports to WebI Reports

there is no Report Comparison tool, n Security Viewer 
present in XIR2

In BOXIR2

We have below tools only

Import Wizard
Report Conversion Tool
Repository Migration Wizard

1) Each version have some licence perion and Licence for 5x end by 2007 
december i guess. Also some enhanced features available in the latest versions.

2) If u want to convert 5.x Deski to XI Deski just open the report in XI.Nothing to 
be done extre. But its safe to have a backup of 5 seperatly. Then you can check 
the data by running the reports in Both Versions.
If u want to covert to Webi use migration tool provided in XI. Here you might 
face some allignment and formating problem will arise.

3)Send your mail id. I will send materials regarding migration

here i am providing my mail-id please provide the material 
on BO
jampana_anil@yahoo.com

Hi,
 Can u plz mail me the documents to abimalliga@gmail.com.It
will be very useful for me

Can you please send some guide on Migration.
My Mail Id:   sree.bo1@gmail.com

Thanks

Can you send it to mee too. Mail Id is winramak@gmail.com

Can you provide me the doc. it will be greatful.. my id is 
cathy_gladston84@yahoo.co.in

Hi... 

  Can u plz provide me migration Pdf help files for BO 6.x 
to BOXIR2...

my email id is pramodmurthy2007@gmail.com

Materilized views are similar to normal views, but the
difference is, materilized views are stored in the databse
and they are refereshed timely to get the new data....

If you want to know the particular job how many records are 
processing/processed for each and every stage inside the 
job then the job Monitoring will help you all the 
information while running the job or after finishing the 
job.
This function available in datastage director.

DS Job Monitor is available in DS Director. Using this you
can monitor the DS job. that is u can get informations like
number rows that is being processed in each link or node,
how many stages, the flow of data ... etc...

hi

varible is reusable function, once create the varible,we 
can use n no of times

you could use an event wait task in the workflow as the 
first  task. Once the event wait task detects the file in 
the specified folder all other sessions tasks wil run.

alternatively you could use unix commanda in the command 
task.

You can use a pmcmd command to trigger the workflow using a 
shell script. You can also use the event wait task 
described in the above answer.

Alternately you can use an UNIX script to work as an active 
listener. This will trigger the workflow once the presence 
of file is detected in a specific directory. A schedular 
tool also will be useful.

If you could describe more about your requirement one can 
add more thoughts into it.

symmetric multiprocessing or SMP involves a multiprocessor 
computer-architecture where two or more identical 
processors can connect to a single shared main memory. Most 
common multiprocessor systems today use an SMP 
architecture. In case of multi-core processors, the SMP 
architecture applies to the cores, treating them as 
separate processors.
SMP systems allow any processor to work on any task no 
matter where the data for that task are located in memory; 
with proper operating system support, SMP systems can 
easily move tasks between processors to balance the 
workload efficiently.
Massive parallel processing (MPP) is a term used in 
computer architecture to refer to a computer system with 
many independent arithmetic units or entire 
microprocessors, that run in parallel. The term massive 
connotes hundreds if not thousands of such units. Early 
examples of such a system are the Distributed Array 
Processor, the Goodyear MPP, the Connection Machine, and 
the Ultracomputer.
Today's most powerful supercomputers are all MP systems 
such as Earth Simulator, Blue Gene, ASCI White, ASCI Red, 
ASCI Purple, and ASCI Thor's Hammer.
In this class of computing, all of the processing elements 
are connected together to be one very large computer. This 
is in contrast to distributed computing where massive 
numbers of separate computers are used to solve a single 
problem.
The earliest massively parallel processing systems all used 
serial computers as individual processing elements, in 
order to achieve the maximum number of independent units 
for a given size and cost.
Through advances in Moore's Law, single-chip 
implementations of massively parallel processor arrays are 
becoming cost effective, and finding particular application 
in high performance embedded systems appplications such as 
video compression. Examples include chips from Ambric, 
picoChip, and Tilera.
Cluster
A computer cluster is a group of linked computers, working 
together closely so that in many respects they form a 
single computer. The components of a cluster are commonly, 
but not always, connected to each other through fast local 
area networks. Clusters are usually deployed to improve 
performance and/or availability over that provided by a 
single computer, while typically being much more cost-
effective than single computers of comparable speed or 
availability

SMP.)SYMTERRIC MULTI PROCESSING SMP:-ALL PROCESSORS WILL BE 
USING SAME MEMORY DISK,MEMORY BUFFERS.HERE PROCESSCORS WILL 
BE WAITING FOR DISK I/O PROCESS.
MPP:MASSIVELY PAPALLEL PROCESSING.)HERE EACH PROCESSOR WILL 
BE HAVING IT'S OWN MEMORY AND MAMORY DEVICES,PHYISICALLY 
ALL THIS PROCESSORS WILL EMBEDDED IN A SINGLE CABIN.AND 
WILL COMMUNICATE THROUGH SHARED MEMORY BUSES.
CLUSTER M/C:) SAME AS MPP ,BUT PHYSICALLY THIS M/C ARE 
HOUSED IN DIFFERENT CABINS AND WILL COMMUNICATE THROUGH 
HIGH SPEED NETWORKS.

Absolutly No. One table can not have more than one PK. But 
u can have 2 cols as 1 PK called Composite Primary Key.

A table can't have two primary key.

Primary key
============
1. A table should have only one primary key
2. More than one column can consist of a primary key – upto 
64 columns
3. Can not be NULL values (missing values)
4. Should be unique values (no duplicate value)

Foreign key
============
1. A table may have zero or more than that upto 32 keys
2. More than one column can consist a primary key – upto 64 
columns
3. Can have NULL values
4. Can have duplicate values
5. There should be a corresponding primary key in the 
parent table to enforce referential integrity for a foreign 
key

No No.. it shouldnt.. One table should have only one PK.

yes

by using the sql override option in the edit properties in 
s.q transformation,

OLAP - Online Analytical Processing, which deals with
analysis of data. It has to deal with historical data too (
for analysis purpose) Not updated frequently. If required
bulk update is allowed. 

OLTP - Online Transactional Processing, which deals with
transactions. For e.g. withdrawals at ATM machines. It
involves many transactions. The databases have to be updated
more frequently after the successful completion of a
transaction.

i am agree with the above answer.olap is denormalized and
oltp normalised

OLTP 
* Is the E-R modleling,there are more concurrent users,
* It contains normalized tables so there is no redundancy.
* More tables,Joins and less Indexes,
* It stores daily transactional data
* It stores very less data 
* It contains mainly current data
* INSERT,UPDATE,MODIFY can be applied on OLTP.
* Performace will be high

OLAP
* It is the Dimensional Modeling
* It contains Denormalised  tables there will be redundancy.
* Less tables,Joins and more Indexes
* It stores operational data
* It contains Historical and Present data
* only SELECT clause is applied on OLAP
* It stores very Huge data
* Performance will be low compared with OLTP

There is only one universe in terminology of BO, but there 
may be many situations based on the usage, where we can 
classify the universes as-

1. Depending on type of data universe objects mapping

a.	Ad-hoc (personal data) – The Universe created for a 
personal usage is called Ad-hoc Universe and these are not 
shared with anybody else.
The reports created using these universes are called Ad-hoc 
Reports and generally users have the rights to store the 
reports in the Inbox. Ad-hoc reporting is a user friendly 
feature designed for all levels of users. Custom reports 
are created using queries.
b.	Non Ad-hoc (corporate data) – The universe created 
for a corporate usage is known as Non ad-hoc Universe these 
are sharable Universes and reports created from these can 
be viewed by all the users.

2. In linking universes scenario
a.	Core universe (Kernel or Master universe) – The 
Universe created and used with another universes for the 
reusability of the components.
b.	Derived universe – The Universe created using Core 
universe and there own required components.

3. Depending on universe parameters.
a.	Secured universe.
b.	Personal universe.
c.	Shared universe.

universes are 3 types : 1)simple universe
2)complex universe 3)dervied universe

 In metric universe aggregate summary is disable. so metric 
universe is not used
in simple uni while the aggregate summary is enable. and 
also it generates the summary.

at 3rd question i dont know.

By having multiple contexts you can utilize the 'multipass' 
sql feature. Multipass: Breaking one large SQL into 
multiple SQLs.If you are using the star schema with two or 
more fact tables,and you enable this feature, BO will 
automatically generate two or more SQLs (i.e. one SQL for 
each fact table object used in the report). Then the 
results will be synchronised in the report. For more on 
multipass concept please refer to Ralph Kimball's Lifecycle 
toolkit (not modelling)book.

Because it will be bit confusing for the users to select 
which context to use if they don't have the knowledge of 
how BO works