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.
Hai..,This Kiran .
how to immlement SCD's through sequential file.please
explain briefly.if nt ask me i will explain ,what i know.
32
How to give a securites in object level&datalevel&pakege
lavel in frame work manager?
29
plz anybody help me, how many reports we can create in one
project?, and what are the names?in real time project at
first what we will do?
23
How can we performance tune reports?
33
what other SAS features do you use for error trapping and
data validation?
24
In source system we have os - windows
BO - 5.1.5. with webi 2.7.1
Repository database - oracle
Reports database - Oracle and DB2
Nearly we have 1200 reports in present system , i want to
move as it is to new hardware
os- windows
bo- 5.1.5 with webi2.7.1
repository - oracle
reports - oracle and db2
let me know is there any migration techniques in same
version.
thanks in advance
Usha
Dear All,
Can anyone tell me that from where i can get Power Center
8.5 S/W for Linux and how can i install Power Center 8.5 or
any 7.x series on Linux Platform.
Thanks in advance
42
what is the difference between OLTP database and data
warehousing database?
What is Discrete and Continuous data in Data mining world?
49
I have a reports on cognos ep7series version3 with database
SQl2000.Now i am migrating database SQL2000 to SQL2005.Then
What happens to cognos reports and also there is reports
cubes then how can i handle this problem please give me
step by step solution b'coz i am new to cognos ep7series
what are the uses of report studio,q.studio,analysis
studio,event studio&.metric studi.
31
what is the use of server manager?
29
plsreply to me...im interested to do the cgnos
certifications relating to report developer.can you suggest
me what kind of certifications andwhere cani get (dumps)
previous quetions and answers for the certification........
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map