CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR
NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
20
by using dsjob..we can run only one job at a time?how can u
run multiple jobs at a time in unix?
24
How to write a left outer join condition by using
Transformer stage in server jobs?
Could any one help me?
165
Hai..,This Kiran .
how to immlement SCD's through sequential file.please
explain briefly.if nt ask me i will explain ,what i know.
161
Hai..,in datastage how to explain project in
interview?please explain any domain please.
231
In Informatica,for the table I can find coreesponding
dependent mappings.Likewise can I find the dependent jobs
with all the information by using the table name
Please Tell me..,I need some Complex Jobs in datastage as
per in interview?how to tell and how to explain?please send
as well as posiible please
217
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.