What are the uses of query explorer? Give example for each
use in detail. It is not given clearly in user guide so
explain in detail.
24
How can we performance tune reports?
33
Then how to select the source by using webi or deski reports
into crystal reports? i think main source is Businessview.
where u import the datasource ?
7
How to apply securities for reports in cognos connection?
insallation procedure for power center 8.1.1 especialy
domain_config
hw to use parameter files
38
where is the cache (lookup, index) created and how can you
see it.
20
Comment on significance of oracle 9i in informatica when
compared to oracle 8 or 8i?
60
If you were told to create many records from one record
show how you would do this using arrays and with PROC
TRANSPOSE?
100
create a job that splits the data in the Jobs.txt file into
four output files. You will direct the data to the
different output files using constraints. • Job name:
JobLevels
• Source file: Jobs.txt
• Target file 1: LowLevelJobs.txt
− min_lvl between 0 and 25 inclusive.
− Same column types and headings as Jobs.txt.
− Include column names in the first line of the output file.
− Job description column should be preceded by the
string “Job
Title:” and embedded within square brackets. For example, if
the job description is “Designer”, the derived value
is: “Job
Title: [Designer]”.
• Target file 2: MidLevelJobs.txt
− min_lvl between 26 and 100 inclusive.
− Same format and derivations as Target file 1.
• Target file 3: HighLevelJobs.txt
− min_lvl between 101 and 500 inclusive.
− Same format and derivations as Target file 1.
• Rejects file: JobRejects.txt
− min_lvl is out of range, i.e., below 0 or above 500.
− This file has only two columns: job_id and reject_desc.
− reject_desc is a variable-length text field, maximum
length
100. It should contain a string of the form: “Level out of
range: <min_lvl>”, where <min_lvl> is the value in the
min_lvl field.
My Question is how do you write the stage variable for
reject rows.
how to do page breaks in cognos 8 Report studio pls give
the navigation
57
what are different storage options supported by oracle ?
55
wat is report linking in BO..I know that 2 reports can be
linked in BO with the help of writing a HTML code .But how.
wat s the code.can u give me the example of code taking e
fashion as the simple univers data provider.
How to give a securites in object level&datalevel&pakege
lavel in frame work manager?
29
Assume u have a 24CPU machine with 24GB RAM, suggest how u
would like to configure Informatica ,like number of
concurrent sessions, RAM requirements etc,max partitions
that u would permit per mapping.
24
what are the components in the cognos connection page
consists (eg: my folder, public folder,directions, schedule
management tool etc.....)